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 is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What is the difference between dropping a database and taking a database offline?
How to store and query spatial data?
Can foreign key be deleted?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is the xml datatype?
What is tempdb database? : SQL Server Architecture
Mention the differences between having and where clause.
What are recommended options to be used while using db mirroring? : sql server database administration
How to create prepared statements using odbc_prepare()?
How to enforce security in sql server? : sql server security
What is update locks?
What is bit data type? What's the information that can be stored inside a bit column?
How does a profiler work?
What are the advantages of using stored procedures?