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
What is .net architecture?
What is the purpose of a web form?
What is page life cycle?
How route table has been created in asp.net mvc?
What are child actions in ASP.Net MVC?
Is .net framework backwards compatible?
Does windows 10 need .net framework?
What is work of clr?
What is .net core framework?
What is .net framework & its benefits?
What are Scaffold templates in ASP.Net MVC?
What is filters in web api?
My organization went through the approval process of supporting the .net framework 2.0 in production. Do we need to go through the same process all over again for the .net framework 3.0? Do I need to do any application compatibility testing for my .net framework 2.0 applications?
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?
What is associationset? : Entity framework