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
What security features are available for stored procedure?
Can you insert NULL in unique column?
How to rebuild indexes with alter index ... Rebuild?
What is fill factor and pad index?
what is blocking? : Sql server database administration
What is coalesce and check constraint in sql server?
Explain what is log shipping?
How many types of cursor type are there?
Define synonym?
What do you understand by recursive stored procedures?
Explain the steps to create and execute a user-defined function in the sql server?
How to drop an existing table?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What are “lock” hints?
What is exporting utility?
