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 the difference between model view and controller?
What is viewbag?
Explain the tools used for unit testing in ASP.Net MVC
How the ‘page lifecycle’ of ASP.Net MVC does works?
Which version of the common language runtime (clr) does the .net framework 3.0 use?
Do I need microsoft .net framework?
What is renderbody?
Is .net core replacing .net framework?
When will the .net framework 3.0 be released?
What is Attribute Routing in ASP.Net MVC?
what is use of entitydatasource control?
What is rxjava used for?
What is the significance of nonactionattribute?
List out few different return types of a controller action method?
What is the 'page life cycle' of an ASP.NET MVC?