What are the magic tables in SQL Server 2000?
- 7 Answers
- 23992 Views
- Infogain, Merrill Lynch, I also Faced
- E-Mail Answers
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 Command line parameters in PLSQL.?
What is query processing?
Which is the main third-party tool used in sql server?
List some major differences between triggers and stored procedures?
What is user-defined functions? What are the types of user-defined functions that can be created?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to create an multi-statement table-valued function?
What is the need for group functions in sql?
What is a trace frag? Where do we use it?
Mention the differences between sql server and mysql.
What are sql server functions?
How to query multiple tables jointly?
How do I debug a stored procedure in sql server?
What are “lock” hints?
Is mysql better than sql server?
