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
Explain query editor regions
Can a cursor be updated? If yes, how you can protect which columns are updated?
Define self join?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
How to insert a new row into a table with "insert into" statements in ms sql server?
What is inline table-value user-defined function?
What is the purpose of self join?
What are the advantages of using cte?
How to add an address record into adventureworkslt?
What is the use of sql profiler in sql server 2012?
last function used in MS Access to convert sql what function will use in sql
How to list all user names in a database?
What are the fixed server level roles? : sql server security
How do I find the query plan in sql server?
What are wait types?