What are the magic tables in SQL Server 2000?
- 7 Answers
- 23980 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 are scheduled tasks in sql server?
What is autocommit mode in sql server?
What is 1nf normalization form?
When to use Inner join & when to use subquery?
Explain the ways to controlling cursor behavior?
Can a database be shrunk to 0 bytes, if not, why?
How do you set a trace flag in sql server?
What are the export options of ssrs?
We need to perform what steps in the following order to work with a cursor?
Can we deploy SSRS reports on our personal website?
Does sql server 2000 full-text search support clustering?
What is the default Port No on which SQL Server listens?
How to create new table with "create table" statements?
What are the five characteristics of good data?
Explain external key management in sql server 2008
