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
Will count(column) include columns with null values in its count?
What are the results of running this script?
Describe the functionalities that views support.
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is stored procedures?
Can you import Microsoft Excel data to SSRS?
what's the difference between a primary key and a unique key? : Sql server database administration
What are filegroups in sql server?
What is a dataset and what are the different types of datasets?
What is subreport?
What is difference between joins and subqueries?
How to receive returning result from a query?
Explain about protocol layer present in SQL server?
What purpose does the model database server?
What is inner join in sql server joins?
