Interested to Buy Any Domain ? << Click Here >> for more details...
What are the magic tables in SQL Server 2000?
- 7 Answers
- 25438 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 are the properties of sub-query?
How adventureworkslt tables are related?
What is Replication?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What triggers long term care?
How do you clear a log file?
Explain syntax for dropping triggers?
What is a sql join?
What is the filtered index?
What is index in an assignment?
What do you understand by integration services in sql server?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What do you know about normalization and de- normalization?
What is difference between global temporary tables and local temporary tables?
