Trigger syntax in sql2000

Question Posted / jsureshdotnet

1 Answers
5472 Views
Wipro, I also Faced
E-Mail Answers

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

diffrance between stored procedure & function in sql server?

2 Answers

You create an assembly to access data in a relational database. This assembly will be used by several ASP.NET applications on your Web server. You need to ensure that all your applications can access the assembly. Which two actions should you take (Each Answer: presents part of the solution.)? (Choose two) A . Run the Assembly Registration tool (Regasm.exe). B . Run the String Name tool (Sn.exe). C . Run the Installer tool (Intallutil.exe). D . Run the Global Assembly Cache tool (Gacutil.exe).

6 Answers CPCL, Syntax Softtech,

which event in global.asx that fires for every request of same user?

4 Answers FactorH,

Define globalization and localization.

0 Answers

Difference between ByVal and ByRef?

2 Answers Microsoft,

What is CLS?

5 Answers IBM, PrimeLine, TCS,

what is wpf and wcf in .net explain with an example?

2 Answers

how to get modified rows from Dataset