Answer Posted / subbarayudu
A Trigger is a block of code,fired whenever data in the underlying table is affected by any of the Data Manipulation Language (DML) statements -INSERT,UPDATE,OR DELETE.
whenever trigger fires,two special tables are created-
1.insert table 2.Delete table.
1.inserted table contains copy of all records that are insetred in the trigger table.
2.deleted table contains all records that have been deleted from trigger table.this table is used to refer old values.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are exact numeric data types in ms sql server?
How do I create a partition table in sql server?
how many clustered indexes can be created on a table? : Sql server database administration
What it means to be triggered?
What is data source view or dsv? : sql server analysis services, ssas
What is autocommit mode in sql server?
How to create function without parameter in sql server?
How can you list all the table constraints in a database?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is an inner join?
What is a periodical index?
Where is localdb stored?
What are ddl triggers and types of ddl trigger?
What is the maximum length of an alert name?
What are the different types of join?
