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 is an indexed view?
Can you leave a union at any time?
How to connect of datebase with sql express.?
Tell me what is the order in which the sql query is executed?
What is SubQuery in SQL Server 2008
Differentiate sql server reporting services vs. Crystal reports?
Equi join and non equi join is possible with sql server?
How to download and install microsoft sql server management studio express?
What is log cache in sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Is it possible for a stored procedure to call itself or recursive stored procedure?
Mention the differences between local and global temporary tables.
Delete duplicate rows without using rowid.
What is scan table/view and seek table/view when its occurs? : sql server database administration
