What are the magic tables in SQL Server 2000?
Answer Posted / maya
While using triggers these Inserted & Deleted tables
(called as magic tables) will be created automatically.
When we insert any record then that record will be added
into this Inserted table initially, similarly while
updating a record a new entry will be inserted into
Inserted table & old value will be inserted into Deleted
table.
In the case of deletion of a record then it will insert
that record in the Deleted table
| Is This Answer Correct ? | 40 Yes | 5 No |
Post New Answer View All Answers
How to list all stored procedures in the current database using ms sql server?
What are the basic features of a trigger in ms sql server?
How to replace null values in expressions using isnull()?
List some of the rules that apply to creating and using a ‘view’
Explain DBCC?
What is check constraint in sql server?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
explain declarative management framework (dmf) in sql server 2008?
What are the new features are introduced in sql server 2012 reporting services?
what's the difference between a primary key and a unique key? : Sql server database administration
Give me any three differences between Truncate and Delete.
How to change the system date and time from SQL Plus Terminal ?
How to drop an existing table?
Difference between connected and disconnected database in .net with sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?