What are Magic Table?
- 34 Answers
- 73468 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / durga prasad.g
MAGIC TABLES NOTHING BUT INSERTED AND DELETED WHICH ARE
TEMPORARY OBJECTS CREATED BY SERVER INTERNALLY TO HOLD
RECENTLY INSERTED VALUES IN THE CASE OF INSERT,TO HOLD
RECENTLY DELETED VALUES IN THE CASE OF DELETE,TO HOLD
BEFORE UPDATING VALUES OR AFTER UPDATING VALUES IN THE CASE
OF UPDATE.
| Is This Answer Correct ? | 67 Yes | 7 No |
Post New Answer View All Answers
What is the meaning of resultset type_scroll_insensitive?
What is indexed view? How to create it?
what's the maximum size of a row? : Sql server database administration
What is deploy, process and build? : sql server analysis services, ssas
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is transactional replication?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
what are the disadvantages of cursors? : Sql server database administration
How data can be copied from one table to another table?
What is the difference between set and select?
Where in ms sql server is ’100’ equal to ‘0’?
Can we use custom code in ssrs?
How do we know if any query is retrieving a large amount of data or very little data?
What is filestream?
Explain what is the purpose of sql profiler in sql server?
