Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 79681 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
What is snapshot parameter in ssrs?
Explain the use of keyword with encryption. Create a store procedure with encryption?
Can sql servers linked to other servers like oracle?
What is a matrix in ssrs?
How to send a ssrs report from ssis?
How you can change the database name in SQL SERVER?
Where the sql logs gets stored?
Define master database?
Explain different backup plans?
Can one drop a column from a table?
How to optimize stored procedures in sql server?
What is trace flag in sql server?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is the difference RDBMS and Graph Database?
Can you explain about buffer cash and log cache in sql server?
