What are Magic Table?
Answer Posted / danish aleem
An implicit trigger is fired when ever we insert, update or delete, then the two temporary tables are created i.e.insert and delete. So these temporary tables are termed as MAGIC TABLES.
* These are named as MAGIC because they are removed automatically when the specified query is committed.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are a scheduled jobs or what is a scheduled tasks?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Explain a differential backup?
What is join query?
System requirements for sql server 2005 express edition?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Which is the main third-party tool used in sql server?
Explain datetime2 data type in sal server 2008?
How you can move data or databases between servers and databases in sql server?
Explain different types of lock modes in sql server 2000?
what is the main function of a query parameter?
Tell me what is difference between clustered and non clustered index?
Explain what are sparse columns?
How you provide security to cube? : sql server analysis services, ssas
Characterize join and name diverse sorts of joins?