Loading
What is syntax for creating triggers ?
3 Answers
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
Mohsin AzamPosted Aug 11, 2016, 6:20 AM
http://www.dotnet-tricks.com/Tutorial/sqlserver/OPUH170312-After-Trigger,-Instead-of-Trigger-Example.html
Munesh SharmaPosted May 31, 2016, 12:43 AM
The syntax for creating triggers is:
Create trigger triggerName
On table name
Trigger type
Operation
As begin
Logic
Statement
End
Sandeep KumarPosted Dec 21, 2015, 2:54 PM