Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 79579 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / sharda prasad shukla
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 ? | 3 Yes | 1 No |
Post New Answer View All Answers
How can you check the level of fragmentation on a table?
Does windows server 2016 come with sql server?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is the language structure to add a record to a table?
Can you explain what are commit and rollback in sql?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is tablix?
What are functions in the sql server?
Explain “row_number()” in sql server with an example?
Define inner join in sql server joins?
What is built-in/administrator?
Explain features and concepts of analysis services?
What is difference between createstatement and preparedstatement?
Why the trigger fires multiple times in single login?
How to create a view on an existing table in ms sql server?
