Interested to Buy Any Domain ? << Click Here >> for more details...
What are the magic tables in SQL Server 2000?
- 7 Answers
- 25479 Views
- Infogain, Merrill Lynch, I also Faced
- E-Mail Answers
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
What happens if an integer is too big for int date type?
Difference between drill down and drill through report.
What protocol does sql server use?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How will you optimize a stored procedure optimization?
how to avoid cursors? : Sql server database administration
Difference between primary key and clustered index?
Do you know the policy based administration feature of sql server 2008?
How to use values from other tables in update statements in ms sql server?
How to create a new schema in a database?
what's the difference between delete table and truncate table commands? : Sql server database administration
Can sql servers link to other servers?
Explain syntax for disabling triggers?
How many databases Microsoft SQL server provides?
Tell me what are the advantages of using stored procedures?
