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
How to provide default values to function parameters?
Explain sql server authentication modes?
What are the approximate numeric data types?
What is a covering index?
What is nonclustered index on computed columns?
how to do partition in sqlserver
what is the maximum size of a row? : Sql server database administration
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Can we add a cpu to sql server?
What is used to replicate sessions between instances in coldfusion clusters?
Explain four layers of abstraction microsoft architectured?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How you can minimize the deadlock situation?