Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the difference between push and pull subscription? : sql server replication
What is the default Port No on which SQL Server listens?
Where are SQL server users names and passwords are stored in sql server?
What is difference between inner join and join?
What are the types of processing and explain each? : sql server analysis services, ssas
How to override dml statements with triggers?
What is lock escalation and what is its purpose?
What is the usage of the sign function?
How to create function with parameter in sql server?
What are the advantages of having an index on the sql server?
What are the character string functions supported by sql server 2005?
Explain what are magic tables in sql server?
What is difference in performance between insert top (n) into table and using top with insert?
What is trigger and different types of Triggers?
What does dml stand for?
