hi ,
I have Audit table , where i have to update the Totals as Inserts + Updates. I created a table already and now i am trying to Alter it. Below is the code , but it is not working.
ALTER TABLE [dbo].[ssis_audit]
ADD CONSTRAINT df_ADDTotal DEFAULT ([Inserts] + [Updates]) FOR [TotalRecords]
What is wrong with the code? can any one please suggest?