What are the magic tables in SQL Server 2000?
- 7 Answers
- 23246 Views
- Infogain, Merrill Lynch, I also Faced
- E-Mail Answers
Answer Posted / kirti kumar agarwal
The INSERTED and DELETED tables, popularly known as MAGIC
TABLES, and update () and columns_updated() functions can
be used to determine the changes being caused by the DML
statements.
Note that the Magic Table does not contain the information
about the columns of the data-type text, ntext, or image.
Attempting to access these columns will cause an error.
| Is This Answer Correct ? | 44 Yes | 3 No |
Post New Answer View All Answers
A trigger can reference objects outside the current database? State true or false.
Define full outer join in sql server joins?
Can we create clustered index on composite key?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
1 01 101 01010
Find columns used in stored procedure?
What is “asynchronous” communication in sql server service broker?
Can foreign key be deleted?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is Cross Join and in which scenario do we use Cross Join?
What are the approximate numeric data types?
What is difference between after and before?
Where can you add custom error messages to sql server?
What are a scheduled jobs or what is a scheduled tasks?
What is repeatable read?
