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
How to insert new line characters into strings?
What is postgresql server?
can any body tell me how to know the password of current user in sql server
What is the difference between mysql and mysqli?
Explain difference between control flow and data flow?
How to set a database state to offline in ms sql server?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is failover clustering overview?
can you implement data mining in SSRS?
What languages bi uses to achieve the goal?
Explain subquery and state its properties?
How to assign null values to variables or columns?
Which command is used for user defined error messages?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Does partitioning help performance?
