What are Magic Table?
- 34 Answers
- 80322 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar
Whenever a trigger is fired in response to the
INSERT,DELETE,Or UPDATE statement the SQL SERVER creates
two temporary tables, Called Magic Table. The Magic Table
called inserted or deleted. The magic table conceptual
tables are similar in structure to the table on which thw
trigger is difined.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain system functions or built-in functions? What are different types of system functions?
How can you append an identity column to a temporary table?
How can we solve concurrency problems?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are the different subsets of sql?
What is standby servers? Explain types of standby servers.
What is in place upgrade in sql server?
do you know how to configure db2 side of the application? : Sql server database administration
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are different types of constraints?
What is the difference between upgrade and migration in sql server?
What is acid mean in sql server?
Where can you add custom error messages to sql server?
Why and when do stored procedure recompile?
