Interested to Buy Any Domain ? << Click Here >> for more details...
What are the magic tables in SQL Server 2000?
- 7 Answers
- 25709 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 @@error in sql?
How to select true false based on column value in sql server?
How you can get a list of all the table constraints in a database? : Sql server administration
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
How do I setup a local sql server database?
Why are views required in the sql server or in any other database?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Does server sql treat char as a variable-length or fixed-length column?
How to handle error or exception in sql?
Can you explain different types of locks in sql server?
What are entities and relationships?
Does an index slow down updates on indexed columns?
What is the index requirement in SQL Azure?
What is implicit cursors?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
