FOR UPdate: CREATE TRIGGER [dbo].[TRG_User_Updated] ON [dbo].[PATIENT_ASSESSMENTS] AFTER UPDATE AS BEGIN SET NOCOUNT ON; INSERT INTO user(userID ) SELECT d.userID FROM INSERTED as d END

http://www.dotnet-tricks.com/Tutorial/sqlserver/OPUH170312-After-Trigger,-Instead-of-Trigger-Example.html

The syntax for creating triggers is: Create trigger triggerName On table name Trigger type Operation As begin Logic Statement End