about triggers?

Answers were Sorted based on User's Feedback



about triggers?..

Answer / anuj

Triggers are special type of procedure which execute based
on events like insert a new row into table or delete or
update the table.

Is This Answer Correct ?    11 Yes 1 No

about triggers?..

Answer / balaji karpurapu

Trigger is a special kind of stored procedures,
Triggers are executed at the time of even takes
INSERT,UPDATE,DELETE actions.
1)Triggers are executed by attaching with table or view
2)Triggers are not stand alone executable

Triggers are classified into three types
1)DML Triggers
2)DDL Triggers
3)CLR Triggers

Syntax:

CREATE TRIGGER TRIGGER_NAME
ON TABLE/VIEW NAME
AFTER/INSTEAD OF
AS
BEGIN
---------
END

Is This Answer Correct ?    5 Yes 0 No

about triggers?..

Answer / guest

Trigger is special kind of stored proceser

Is This Answer Correct ?    4 Yes 2 No

about triggers?..

Answer / raj

this special kind of stored procedure,this is triggered
while insert, delete,update

Is This Answer Correct ?    1 Yes 1 No

about triggers?..

Answer / riju

Triggers are like auto executable store procedures.Triggers
can be execute before or after any DDL or DML statements.

Is This Answer Correct ?    0 Yes 0 No

about triggers?..

Answer / arun kumar

trigger is proggramed procedures
with the help of trigger we can insert, delte, update data
from two tables

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Dot Net Framework Interview Questions

what is Framework?

3 Answers  


What is JIT and how is works ?

10 Answers  


How we can call a javascript function on the change of a dropdown list in mvc?

0 Answers  


what is mean by COM (component object model) and component based software development? Is it .NET is first COM based technology? Please answer me. Advance thanks.

1 Answers   Excel,


What is the difference between entity framework and mvc?

0 Answers  






What is the advantage of using asp.net routing?

0 Answers  


What is entity graph? : Entity framework

0 Answers  


How does servicing work for the .net framework 3.0? If I install the .net framework 3.0, can I get service updates for the .net framework 2.0?

0 Answers  


How we can register the Area in ASP.Net MVC?

0 Answers  


What does CLR do as soon as an assembly is created ?

2 Answers   MMTS,


What are the types of authentication in .net

1 Answers  


Why to use Html.Partial in ASP.Net MVC?

0 Answers  


Categories