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
What is scrollable cursor?
What is temporary stored procedure?
How can you control the amount of free space in your index pages?
How to optimize stored procedures in sql server?
What area unit the various kinds of info compression introduced in sql server 2008?
What happens if we shrink log file in sql server?
What is a derived table?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
what are triggers? : Sql server database administration
What are the different Topologies in which Replication can be configured?
What are the advantages of using cte?
What is the importance of concurrency control?
Explain activity monitors
What are the restrictions that views have to follow? : SQL Server Architecture
How to modify existing triggers using "alter trigger"?