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 is index, cluster index and nonclustered index?
How do I find the transaction log size in sql server?
Explain what is the function of sql server agent windows service?
How do you delete a data source?
What are commit and rollback in sql?
how to trace the traffic hitting a sql server? : Sql server database administration
What is a data collection table?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How do you delete a trigger?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What is a transactions?
What is trace flag in sql server?
How to copy the tables, schema and views from one sql server to another?
Explain differentiate between a having clause and a where clause?
Explain sql server service broker?
