Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / punit chauhan
whenever a trigger is fire in response to an insert, delete and update statement.
Two special tables create, these are the inserted and deleted tables, they are also referred as magic tables.
* whenever we insert any record into the table then trigger use inserted table.
* whenever we delete any record into the table then trigger use deleted table.
* whenever we update any record into the table then trigger use inserted and deleted tables.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What does it mean to manipulate data?
What is equi join with example?
What do you mean by SQL injection attack?
what are database files and filegroups? : Sql server database administration
Explain what is raid and what are different types of raid levels?
What is sql server profiler trace data file?
What is bit data type? What's the information that can be stored inside a bit column?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
What are the different types of backups avaialabe in sql server 2005?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What are distinctive joins find as a part of sql?
How to execute stored procedure and set temp table in sql server?
What is dbcc?
What is transaction server distributed transaction?
