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 can you find out how many rows returned in a cursor?
difference between Clustered index and non clustered index ?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Detail about query optimizer?
What happens when the SQL Azure database reaches Max Size?
How to verify the port number of the sql server?
Can truncate be rolled back?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
In how many ways you can invoke ssrs reports?
Can you explain powershell included in sql server 2008?
What are the disadvantages of indexes?
Write a sql query to get zero records from a table having n number of records?
What is data source in connection string?
Is foreign key unique?
What is statement level trigger?