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 stored procedure can you use to display the current processes? : Sql server administration
What is difference between index seek vs. Index scan?
What is sql injection and why is it a problem? : sql server security
How to create hyperlink from returned sql query ?
How many types of keys are there?
What is an indexing technique?
How to insert multiple rows with one insert statement in ms sql server?
Different types of keys in SQL?
What is a coalesce function?
how many bits ip address consist of? : Sql server database administration
What is the return type of executeupdate ()?
How to backup SQL Server Reporting Services ?
Explain what are page splits? : SQL Server Architecture
Explain Geography datatype in SQL Server
What is the difference between ddl,dml and dcl commands?