Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77661 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 performance monitor?
Explain how many normalization forms?
Data table as parameter in sql server?
Write a SQL queries on Self Join and Inner Join.
what is a sub-report?
What is data source object?
Explain what is the function of sql server agent windows service?
What happens if we shrink log file in sql server?
What method is used by the Command classes to execute SQL statements that return single values?
How you trouble shoot when any job fails
What is difference between aggregate and analytic function?
What is the difference between composite index and covering index?
Do you know what are the differences between lost updates and uncommitted dependencies?
Explain what are the events recorded in a transaction log?
What are data files?
