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 a mixed extent?
What is faster join or union?
Tell me about normalization in DBMS.
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What are the basic functions for master, msdb, model, tempdb databases?
What happens if you delete a table that is used by a view?
Can we insert data into a view?
How many tables can be joined in SQL Server?
How do you improve the performance of a SQL Azure Database?
Explain the difference between primary keys and foreign keys?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Define Wed Edition in SQL Azure?
Distinguish between nested subquery and correlated subquery?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
Name three of the features managed by the surface area configuration tool? : sql server security