What are Magic Table?
- 34 Answers
- 73469 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / digvijay kumar singh
Magic table is Temporary type table. it is created when
trigger perform the insert,delete and update action. trigger
have two type magic table:-
1:- inserted table.
2:- deleted table.
when trigger perform the insert and update action on table
then trigger used the Inserted magic table and deleted magic
table used at deletion time.
i hope you will understand..................
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are a scheduled jobs?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Which language rdl files made of?
What is a transactions?
Can we call future method from trigger?
How can we check the sql server version?
How to connect Azure federated root database and apply federation in entity framework?
What are the different type of replication in sql server?
What is store procedure? How do they work? When do you use?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is the contrast amongst drop and truncate?
what is denormalization and when would you go for it? : Sql server database administration
Do you know what is replace and stuff function in sql server?
What are truncate options available in sql server? : sql server database administration
