What are the magic tables in SQL Server 2000?
Answer Posted / vijayabhaskarreddy
wen we are performing DML operations into table . amagic
table created in the memory.
inserted magic table
deleted magic table
update magic table
| Is This Answer Correct ? | 3 Yes | 21 No |
Post New Answer View All Answers
What do you understand by intent locks?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Why use view instead of a table?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How to generate create function script on an existing function?
How to execute the cursor queries with "open" statements?
Explain comment on transactions?
How do I start sql server agent automatically?
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
What is the recovery model? List the types of recovery model available in sql server?
How real and float literal values are rounded?
How to create a trigger for insert only?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Define right outer join in sql server joins?
What are different types of join?