Interested to Buy Any Domain ? << Click Here >> for more details...
What are the magic tables in SQL Server 2000?
- 7 Answers
- 25447 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 the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
List out different types of normalizations in sql server and explain each of them?
What is mean by candidate key?
Can you explain different types of joins?
What is blocking and how would you troubleshoot it? : sql server database administration
What are the different types of sql server replication? : sql server replication
How to execute multiple stored procedures at one time in sql server?
What is the Main Difference between ACCESS and SQL SERVER?
What are sql servers used for?
What is report subscription?
What are partitioned views and distributed partitioned views?
How to rebuild all indexes on a single table?
What is the contrast between sql and pl/sql?
How to send a ssrs report from ssis?
What are the benefits of normalization?
