Question:
What magic table What happen when we run any command or stored procedure is it compile ?
Answer:
Magic Tables are tables associated with triggers..i.e , insert and delete table. Source: CoolInterview.com
Answered by: Amit | Date: 2/3/2009
| Contact Amit
There are 2 Magic Tables in SQL server Inserted and Deleted.<br>These are mantained by SQL server for Internal processing whenever an update, insert of delete occur on a table. However, we can refere these tables in a Trigger.<br>Whenever an update table statement is fired SQL server mantains the original row before updation in a deleted table and New (updated )row in a Inserted Table.<br><br>Same is the case when an insert is fired Only Inserted table is populated with inserted Row.<br>and when Delete table statement is fired Deleted table is populated with the deleted row. Source: CoolInterview.com
Answered by: archana | Date: 4/14/2009
| Contact archana
There are 2 Magic Tables in SQL server Inserted and Deleted. Source: CoolInterview.com
Answered by: me | Date: 4/15/2009
| Contact me
When we run any command on the database,it will got complied but instead when we run any procedure they got compliled at the first time when they are fired afterwards they do'nt got compile.<br>That's why procedure's gave us faster output than command,and in any type of application we prefer to use procedures. Source: CoolInterview.com
Answered by: Deepak Semwal | Date: 5/8/2009
| Contact Deepak Semwal
Magic tables are created when data is inserted or updated <br>in the normal tables. They get deleted when the commit is <br>done. They are used for the auditing purposes.<br>They are useful in keeping track of the insertion and <br>updation on the database. Source: CoolInterview.com
Answered by: Abhishek Saxena | Date: 8/10/2009
| Contact Abhishek Saxena
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|