Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 78672 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
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is user-defined functions? What are the types of user-defined functions that can be created?
can a table be moved to different filegroup? : Sql server administration
How to test a dml trigger in ms sql server?
What are the different acid properties?
Is it true, that there is no difference between a rule and a check constraint?
What is create command?
What is faster join or union?
How do I trace a query in sql server?
Explain what is scheduled job and how to create it?
How to disable a login name in ms sql server?
How to provide login information for a new odbc dsn?
How can a user-defined datatype be created?
What is indexing and its types?
Tell me what is the order in which the sql query is executed?
