SQL Syntax Creating a Trigger
Creating a Trigger Examples
CREATE TRIGGER trigAddCountry
ON Country
FOR INSERT
AS
DECLARE @Newname VARCHAR(100)
SELECT @Newname =(SELECT Name FROM INSERTED)
PRINT 'THE Country ' + @Newname + ' IS ADDED.';
See also SQL syntax for:
ORDER BYRIGHT JOINSingle Line CommentSTDEVPAVG
