Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 79669 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / sabahuddin
Usually Inserted and Deleted Tables are called Magic Tables.Magic Tables does not contain the information about
the Columns of the DataType text,ntext or image.These are maintained by SQL Server for internal processing whenver an update,insert,Delete occur on table.However we can refer these tables in Triggers.
Whenever an updated table statement is fired SQL Server Maintains the original row before updation in a deleted table and New(Updated) row in inserted table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a trace frag? Where do we use it?
How to use group functions in the select clause in ms sql server?
What is the optimization being performed in oracle and SQL Server?
What is a unique key constraint?
What is openrowset sql server?
What according to you is the difference between mysql and sql server performance?
Explain how to send email from sql database?
What is transaction server isolation?
List the different normalization forms?
Tell me extended events in sql server 2008?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How fixed length strings are truncated and padded?
What is an indexing technique?
What is the difference between getdate and sysdatetime?
