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
Explain what is asp.net mvc?
What are the benefits of .net framework?
Is .net framework 4.8 the last version?
will there be any issues adding a table without primary keys to a data model?
What is the difference between renderaction and renderpartial?
Explain peek method in tempdata in asp.net mvc?
Which is the root namespace for fundamental types in .net framework?
What is web api‘s in asp.net mvc 4 ?
Is it possible to share a view across multiple controllers?
What is edm (entity data model)? : Entity framework
explain what does .edmx file contains?
Is .net framework going away?
Explain the advantage of packaging over xcopy in .net?
What is orm entity framework?
What is the .net framework?