What is Magic tables.
What is Magic tables in sql server.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vijaya KadiyalaPosted Feb 27, 2009, 3:56 PM
Hi
glad to see that you are clear in basics.
Thanks -- Vijaya Kadiyala
Purushottam RathorePosted Feb 27, 2009, 4:20 AM
Vijaya KadiyalaPosted Feb 26, 2009, 12:32 PM
Hi
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.
Thanks -- Vijaya Kadiyala
Bechir BejaouiPosted Feb 26, 2009, 6:45 AM