about triggers?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / raj
this special kind of stored procedure,this is triggered
while insert, delete,update
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
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 |
what is Framework?
What is JIT and how is works ?
How we can call a javascript function on the change of a dropdown list in mvc?
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.
What is the difference between entity framework and mvc?
What is the advantage of using asp.net routing?
What is entity graph? : Entity framework
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?
How we can register the Area in ASP.Net MVC?
What does CLR do as soon as an assembly is created ?
What are the types of authentication in .net
Why to use Html.Partial in ASP.Net MVC?