How will you create a DML Trigger?

 Posted by Chvrsri on 12/8/2010 | Category: Sql Server Interview questions | Views: 1944 | Points: 40
Answer:

The procedure to create a DML trigger is :

CREATE TRIGGER (TRIGGER_NAME)
ON (TABLE_NAME)
AFTER (INSERT OR UPDATE OR DELETE)
AS
PRINT 'MESSAGE'
GO


Source: My Own Observation | Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response