How will you create a DML Trigger?

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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

Bookmark It

< Previous : In order to apply .net Remoting what are the essen ...

Next > : Can we work on both (After) and (InsteadOf) Trigge ...

Comments or Responses

More Interview Questions by Chvrsri

Can we work on both (After) and (InsteadOf) Triggers in SQL on a singl ...
What does XML used for ?
What is Screen Scraping ?
What is the use of DIAGNOSTICS namespace in C#.Net?
What is a VIEW in Sql Server?
When were Partial Methods intorduced ? (FrameWork )
Which of the following is false regarding Constructors? a)There can b ...
Where does Static variables store ?

Latest Interview Questions

What is the purpose of Model database ?
How do you declare an unnamed procedure within .NET?
What is Finalizer?
What is Zero-Width Assertions in C#?
What is Regular Expressions in C#.NET?
Can we create web application with out web.config file?
How the SELECT statement parsed/executed by the SQL Server engine ?
Describe the life cycle of a web application? When are webforms instan ...
More ...