The INSERTED and DELETED tables are the magic tables anand ur right rosha

What are Magic Table?

Question Posted / kar

Answer Posted / kar

The INSERTED and DELETED tables are the magic tables
anand ur right
roshan and shakila are totally wrong
prakash u r also wrong

Is This Answer Correct ?

50 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How to start and end transact-sql statements?

971

How to change parameter value inside the report?

153

When we should use @@error?

914

How we can compare two database data?

875

Can we delete data from a view?

883

Can we insert data if clustered index is disabled?

893

What are the new features of sql server 2012 reporting service?

123

What is the Main Difference between ACCESS and SQL SERVER?

1068

What is a schema in ms sql server 2005?

917

How to display a past time in days, hours and minutes?

966

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

907

Why is normalisation important?

903

What you can do to delete a table without the delete trigger firing?

920

List some case manipulation functions in sql?

968

How fixed length strings are truncated and padded?

942