Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are Magic Table?

Answer Posted / ajay kumar

Whenever a trigger is fired in response to the
INSERT,DELETE,Or UPDATE statement the SQL SERVER creates
two temporary tables, Called Magic Table. The Magic Table
called inserted or deleted. The magic table conceptual
tables are similar in structure to the table on which thw
trigger is difined.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1107


What do you understand by mirroring?

1044


What are the different types of collation sensitivity in sql server?

1156


How to integrate the ssrs reports in application?

1039


How to view existing indexes on an given table using sys.indexes?

1148


Explain about link server in sql server?

1104


What is difference between sql and sql server?

1077


How to implement service broker?

1067


What is a user-defined function in the sql server and what is its advantage?

1136


What is Federation and Federation Member?

94


What is self contained scalar sub query?

1014


Can two tables have the same primary key?

1263


What is snapshot parameter in ssrs?

155


What are parameterized reports?

204


Do comments need to go in a special place in sql server 2005?

908