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
How many types of functions are there in sql server?
What is the difference between varchar and varchar types?
How to implement service broker?
List some advantages and disadvantages of stored procedure?
What is scrollable cursor?
What is normalization 1nf 2nf 3nf?
Define primary key?
Write query to return all rows sql?
What are the three different part of rdl file explain them?
How much is a sql server license?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Describe different Processing Modes offered by SSRS?
Why should one not prefix user stored procedures with ‘sp_’?
How would we use distinct statement? What is its use?
When a primary key constraint is included in a table, what other constraints does this imply?
