Trigger in SQL Server

Creates a new trigger, and when updated with the UPDATE statement, age automatically becomes the current time, even if the age field is not updated.

CREATE TRIGGER Tgr_modstamp  on  Update as  update  SS  SET=GETDATE  ()  WHERE in (SELECTDISTINCT from Inserted)

This way, when you insert new data, the age default is the current time, and SQL does not need to insert the data for this field, and the following dateofaddmission is also a meaning, just another way.

CREATE TABLE [dbo].[SS] (    [ID]   VARCHAR( -) not NULL,    [Name] VARCHAR( -)NULL,    [Type] NCHAR(Ten)NULL,    [Sex]  NCHAR(Ten)NULL,    [ Age]  NCHAR( -)CONSTRAINT [DF_SS] DEFAULT(getUTCDate ())NULL,    [dateofaddmission] datetime default Current_timestamp     PRIMARY KEY CLUSTERED([ID] ASC));

Trigger in SQL Server