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 microsoft sql server functions?
What are the different ways you can create databases in sql server?
What is the difference between char and varchar2 datatype in sql?
Can you type more than one query in the query editor screen at the same time?
What is sql server agent and what are the two modes of authentication in sql server?
How to provide default values to stored procedure parameters?
What happens if you delete a table that is used by a view?
What are the different methods available under sqlcommand class to access the data?
How to list all field names in the result set using mssql_field_name()?
Name and describe few console utilities for ssrs?
Define primary key?
What is xml datatype?
What is nested transaction?
What is a trace frag?
How many replicas are maintained for each SQL Azure database?