Sandeep Kumar
What is syntax for creating triggers ?
By Sandeep Kumar in SQL Server on Dec 21 2015
  • Mohsin Azam
    Aug, 2016 11

    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

    • 0
  • Munesh Sharma
    May, 2016 31

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

    • 0
  • Sandeep Kumar
    Dec, 2015 21

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

    • 0