Forum Discussion
BenjaminChew
Aug 19, 2025Copper Contributor
adding computed column to MS SQL
would like to check how to add a computed column with the following requirement Column value will be C-yyyyMMdd-0001 where date will be from the CreatedDate column in the same table. 0001 is an a...
BenjaminChew
Aug 20, 2025Copper Contributor
column to be filled with a trigger.
rodgerkong
Aug 22, 2025Iron Contributor
Could you add a small table in your db to record the max number, or add the table by your dba?