Answer Posted / ashish tripathi
A trigger is a stored procedure that goes into effect when
you insert, delete, or update data in a table. You can use
triggers to perform a number of automatic actions, such as
cascading changes through related tables, enforcing column
restrictions, comparing the results of data modifications,
and maintaining the referential integrity of data across a
database.
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
Explain the concept of recursive stored procedure.
How to return the top 5 rows from a select query in ms sql server?
Differentiate between a having clause and a where clause.
What is master database? : SQL Server Architecture
What do you mean by table and field in sql?
Explain what is analysis service repository?
Explain user defined functions?
What language is sql server written in?
What is the difference between varchar and varchar types?
What are the properties of the transaction?
what are defaults? : Sql server database administration
What is meant by dirty read?
How to generate create view script on an existing view?
What are the different types of normalization?
How to retrieve error messages using odbc_errormsg()?