What are the magic tables in SQL Server 2000?
- 7 Answers
- 23983 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
what is the difference between count(*) and count(1) ?
Explain the rules for designing files and file groups in sql server?
What is the purpose of linked server configuration in sql server?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
How to execute a sql statement using mssql_query()?
What is best institute to Learn DotNET And SQL in chennai?
What is single-user mode?
What is report subscription?
How to change parameter value inside the report?
Can we call stored procedure in view in sql server?
How to create new databases with "create database" statements?
What is the sql server agent?
What are the main differences between #temp tables and @table variables and which one is preferred?
how would you improve etl (extract, transform, load) throughput?
What is delete query?
