Forum Discussion
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...
Should this column be inserted with other columns in one SQL command? Or the column can be filled with a trigger? Or the insert script can be writen in a Stored Procedure?
column to be filled with a trigger.
Could you add a small table in your db to record the max number, or add the table by your dba?
