What are the magic tables in SQL Server 2000?
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
How to concatenate two binary strings together?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are the types of sql server?
Describe in brief authentication modes in sql server.
What is the native system stored procedure to execute a command against all databases?
Which tcl commands are available on the sql server?
How to rebuild the master database?
can a database be shrunk with users active? : Sql server administration
Write a code to select distinct records without using the DISTINCT keyword.
What is indexing explain it with an example?
What is a full text index?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
How do we Backup SQL Azure Data?
How to compare the top two records using sql?