Trigger syntax in sql2000



Trigger syntax in sql2000..

Answer / sandeep kharat

CREATE TRIGGER TriggerName ON TableName
AFTER Insert, Update, Delete
AS
Triger Code


and


CREATE TRIGGER TriggerName ON TableName
INSTEAD OF Insert
AS
Triger Code

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More ASP.NET Interview Questions

what is the trace in ASP.NET

4 Answers  


What Name space does the web page belon in the .net framework class hierarchy?

1 Answers   L&T, Wipro,


suppose i am Admin in my application and i have to terminate the session of the particular user in my application.........how can i do it....?????

1 Answers   L&T,


What are Caching techniques in .NET

0 Answers   Microsoft,


Question asked by one of interviewer in panal is given below: We have 2 user control on same page ,1st user control contains textbox and a button while 2nd user control have label. when ever we click on button click of 1st custom control button the value of the textBox will get updated into Label of 2nd custom control. How to do this.Your help will be appreciated.

1 Answers  






What is custom attribute? How to create?

0 Answers  


What are httphandlers and httpmodules and difference between them?

0 Answers  


Write a standard lock() plus double check to create a critical section around a variable access?

1 Answers  


I need some questions regarding asp.net for 1.5yrs of Experience.

1 Answers  


What is SQL injection?

2 Answers  


What is the difference between Server.Transfer and Response.Redirect?

5 Answers  


What is http pipeline in asp.net?

0 Answers  


Categories