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
Your table has a large character field there are queries that use this field in their search clause what should you do?
What are the different editions available in sql server 2000?
What is shared lock?
Explain the stored procedure?
Which is the latest version of sql server and when it is released?
What is clustered vs nonclustered index?
What is sql server database?
explain different levels of normalization? : Sql server database administration
Can we hide the definition of a stored procedure from a use?
What is the function of inner join?
Can we do dml on views?
How do you troubleshoot errors in a SQL Server Agent Job?
How to apply filtering criteria at group level with the having clause in ms sql server?
Explain features and concepts of analysis services?
Does a sql server 2005 select statement require a from?
