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
Can we use trigger new in before insert?
What are the dmvs?
what do you understand by change data capture?
How to use the inserted and deleted pseudo tables?
What is set nocount on and what is set nocount off?
What do you understand by hotfixes and patches in sql server?
What do you mean by data integrity?
List the different types of joins?
What is auditing in sql server?
When do you think a developer should use sql server-based cursors?
Tell me the difference between clustered and non-clustered index?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is the difference between varchar and varchar(max) datatypes?
How to write a query with a left outer join in ms sql server?
