INSERTED and DELETED tables known as MAGIC TABLES.

What are Magic Table?

Question Posted / sandeep yadav

Answer Posted / sandeep yadav

INSERTED and DELETED tables known as MAGIC
TABLES.

Is This Answer Correct ?

42 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to create new databases with "create database" statements?

959

What is partitioned view?

853

Do you know what are acid properties?

1018

What are the properties of the transaction?

968

Explain optimistic and pessimistic concurrency?

927

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1945

What is log ldf?

930

How do triggers work?

879

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1079

What is raid, and how it can influence database performance?

1008

How each E-R model constructs can be mapped to the relational model?

920

What are drillthrough reports?

141

How to find the service pack installed? : sql server database administration

971

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

955

How you can get the list of largest tables in a database?

943