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

Define repository pattern in mvc.net? : asp.net mvc

0 Answers  


What method do you use to explicitly kill a users session?

2 Answers   Siebel Systems,


• What Session State providers are available in ASP.NET? What are the pros and cons of each?

2 Answers   Infosys,


Can I combine classic asp and asp.net pages?

0 Answers  


Difference between web.config and app.config?

3 Answers   ITC Infotech, Jenesys Technologies,






why we should use more than one web.config files in our application? I have two web.config files in my application. One in the root directory and another one inside a sub folder. When the application runs which web.config file will run? why?

1 Answers  


What is autopostback in dropdownlist in asp net?

0 Answers  


Explain the difference between overriding and overloading?

0 Answers  


can we edit records from repeater control

2 Answers  


What are ASP.NET Web Forms? How is this technology different than what is available though ASP (1.0-3.0)?

1 Answers   Siebel Systems,


What does the "EnableViewState" property do?

2 Answers  


What are the disadvantages of view state?

0 Answers  


Categories