Answer Posted / 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 |
Post New Answer View All Answers
Can I uninstall microsoft .net framework?
Explain test driven development (tdd) ?
What are the advantages of asp.net mvc?
Is it possible to share a view across multiple controllers?
What is meant by viewdata?
What is latest version of .net framework?
Give an example for authorization filters in an asp.net mvc application?
What is the domain object?
What is model first? : Entity framework
What is representational state transfer (rest) mean?
What are child actions in ASP.Net MVC?
What is entityset? : Entity framework
How to update one of my table in database at 4pm every day how it is possible?
Explain Model, view and Controllers in Asp.Net MVC?
Explain the new features 3.5 framework against with the tool?