What is Trigger?
Answers were Sorted based on User's Feedback
Answer / koti-khammam
Trigger is a special type of stored procedure that will
fire automatically when ever data modifications like
INSERTIONS,UPDATIONS or DELETIONS occurs on the table.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / kaushik chatterjee
A trigger is some what simillar to stored procedure. It is
written to perform a set of predefined actions when a
perticular database objecy such as tables,views are
DELETED,INSERTED,UPDATED.
Triggers are implicitly called and are NOT instactiated by
the user. Once written, it will be called automatically by
the DBMS engine when a UPDATE/DELETE/INSERT operation is
performed on the database object for which the trigger is
intended or written.
Triggers can be written for any one of the 3 operations
written above or all of them.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / pawan378
above answers are correct.
let me add some thing.
Trigger
(Pre - Trigger) is a dynamic Rule that should be done before
Data modification Happens.
or
(Post - Trigger) is a Consequent step that should be taken
as soon as the Data Happens.
Is This Answer Correct ? | 5 Yes | 0 No |
What is temporary table in sql server? Why we use temp table?
What is a Join and explain its types?
What is the server name in sql server?
What is read uncmmited?
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.
How to retrieve field values using mssql_result()?
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
What is a user-defined function in the sql server and what is its advantage?
What are the advantages of stored procedure in sql server?
What are relationships and mention different types of relationships in the dbms
how many clustered indexes can be created on a table? : Sql server database administration
What is surrogate key? : sql server analysis services, ssas