Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77614 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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
List the various tools available for performance tuning?
Why we need sql server?
how you can configure a running aggregate in SSRS?
Explain what are the database objects? : SQL Server Architecture
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is the difference between Clustered and Non-Clustered Index?
What are the ways available in sql server to execute sql statements?
How does index makes search faster?
Explain what is the difference between union and union all?
How retrieve field names from the table in SQL through JAVA code?
What happens if date-only values are provided as date and time literals?
What is model database? : SQL Server Architecture
Explain about sql server login?
How to update a field in SQL after ALTERING a row?
