What are Magic Table?
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
Are resultset updatable?
How do I start sql server 2016?
In which files does sql server actually store data?
How to create an multi-statement table-valued function?
What is clr ddl trigger?
What does dml stand for?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
Define model database?
Explain what are magic tables in sql server?
How to drop an existing table with "drop table" statements in ms sql server?
What is the difference between getdate and sysdatetime?
How to disable a login name in ms sql server?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What are the general features of sql server management studio? : sql server management studio
What are the acid properties?