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
Where are sql server user names and passwords stored in sql server?
How to get the definition of a view out of the sql server?
What is cte (common table expression)?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is db stored procedure?
Name the different type of indexes in sql?
How to find out what is the default collation in a database?
How to insert multiple rows with one insert statement in ms sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is nolock?
How you can minimize the deadlock situation?
What is ssl in sql server?
What happens if null values are involved in bitwise operations?
How to verify a login name with sqlcmd tool?