What are Magic Table?
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 are 3 ways to get a count of the number of records in a table?
Can you explain what is indexed view? How to create it?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is inline table-value user-defined function?
what is the difference between count(*) and count(1) ?
what are the core components of SSRS?
How can we solve concurrency problems?
What is a not null constraint?
What do you mean by an execution plan? Why is it used? How would you view it?
What is the cartesian product of the table?
Why union all is faster than union?
Give main differences between "Truncate" and "Delete".
What is filtered index?
Explain the relational database management system (rdbms)?
What is a DBMS, query, SQL?