Interested to Buy Any Domain ? << Click Here >> for more details...
What are the magic tables in SQL Server 2000?
- 7 Answers
- 25486 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 command used to recompile the stored procedure at run time?
Can foreign key be deleted?
What are the parts of a function?
How to name query output columns in ms sql server?
If a stored procedure is taking a table data type, how it looks?
What is catalog views?
What is a covered index?
What is the recursive stored procedure in sql server?
How to count rows with the count(*) function in ms sql server?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
How many types of database relationship in sql server?
How to create a dml trigger using create trigger statements?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is oltp (online transaction processing)?
What are a scheduled jobs or what is a scheduled tasks?
