What are the magic tables in SQL Server 2000?
Answer Posted / jerry joseph
NO THERE IS NO UPDATED MAGIC TABLE
only 2 magic tables
- INSERTED
- DELETED
in case of an Update operation the original row is stored in
the DELETED table and the new row is saved in the INSERTED table
| Is This Answer Correct ? | 31 Yes | 0 No |
Post New Answer View All Answers
What are binary string data types in ms sql server?
What are approximate numeric data types in ms sql server?
How to create a trigger for insert only?
What is the difference between a check constraint and a rule?
What does set rowcount do?
Does sql server 2000 clustering support load balancing?
Can sql servers link to other servers like oracle?
what is raid and what are different types of raid configurations? : Sql server database administration
What are the system database in sql server 2008?
what is difference between view and Dip.
What do you understand by triggers and mention the different types of it?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What are the requirements to use odbc connections in php scripts?
What does ss stand for sexually?
Explain a differential backup?