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 |
If we write return statement in finally block will it works fine or throws any error?
can we call the garbage collector to run explicicitly?
Which is the default http method for an action method?
What's the .NET class that allows the retrieval of a data element using a unique key
What is the difference between structures and enumeration ?
How to Redirect Tracing to a File
What is filters in web api?
How the framework differentiate between 2 version dlls? eg Version 2.0 and 2.1 dlls are there. both are referred in the code.but we are using only name of that dll not the version number. in run time how the framework know which dll has to be referred?
What is the use .glimpse in mvc?
What are the main components of .net framework?
exe abrevatiom
How to answer for project questions..?