Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 78671 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 are wait types?
What are the authentication modes in sql server? How can it be changed?
What options are available to audit login activity? : sql server security
Can we call stored procedure in trigger?
What is use of except clause? How it differs from not in clause?
Write down the syntax and an example for create, rename and delete index?
Where are SQL server users names and passwords are stored in sql server?
What are the requirements on sql server network connections?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is database architecture? : SQL Server Architecture
How are the unique and primary key constraints different?
Do you know what are acid properties of transaction?
What do you mean by tablesample?
If user is owning any SQL Objects, can we drop that user
Write a SQL query to make a column as unique?
