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
How can I return string result from action in asp.net mvc?
Is http stateful or stateless?
How we can register the Area in ASP.Net MVC?
What is partialview in asp.net mvc?
What is needed for running an application built on winfx on the .net framework 3.0?
What does a viewmodel do?
How to enable Attribute Routing?
Is .net framework going away?
Can you please explain the request flow in ASP.NET MVC framework?
i just want to write an exam regarding .net?plz give me information about taking a test?where to pay 4 d exam,exam centre?
What is associationset? : Entity framework
What are the advantages of mvc over asp.net?
Explain the new features added in version 4 of mvc (mvc4)?
Why is the .net framework 3.0 a major version number of the .net framework if it uses the .net framework 2.0 runtime and compiler?
What is the difference between partial and renderpartial?