Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77962 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
How many categories of data types used by sql server?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is the difference between truncate and delete commands?
How can you ensure that the database and sql server based application perform well?
What is data mart? : sql server analysis services, ssas
What is a ddl statement?
How the authentication mode can be changed?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Explain the dirty pages?
How will you decide the active and passive nodes?
What is row_number () and partition by in sql server?
What programming language would you use to create embedded functions in ssrs?
What is checkpoint in sql server?
Delete duplicate rows without using rowid.
What do you understand by the denormalisation?
