Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Explain about merge replications?
is there a column to which a default can't be bound? : Sql server database administration
What is normalization according to you and explain its different levels?
How to rebuild indexes with alter index ... Rebuild?
How does stuff differ from the replace function?
What is scheduled job and how to create it?
What is a covering index?
What is indexing explain it with an example?
How many ways to create table-valued functions?
What are the new features are introduced in sql server 2012 reporting services?
Explain mixed authentication mode of sql server?
Explain tablesample?
We need to perform what steps in the following order to work with a cursor?
Explain few examples of RDBMS?
What is log in sql server?
