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
Explain filestream storage of sql server 2008?
Why it is recommended to avoid referencing a floating point column in the where clause?
What are the different types of upgrades that can be performed in sql server?
How to create database with physical files specified in ms sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is report rendering ?
What are the extra roles available in msdb? : sql server security
How to assign null values to variables or columns?
Why is replication required on the sql server?
Why union all is faster than union?
What are the types of subquery?
How to enable tcp/ip protocol on a sql server?
What do you do in data exploration
What is the maximum size of sql server database?
Difference between report and query parameter. Why do we need different type of parameter?