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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Where are magic tables stored ? Is it in the same database
where it is created ?

Question Posted / retom

Answers were Sorted based on User's Feedback



Where are magic tables stored ? Is it in the same database where it is created ?..

Answer / digvijay kumar singh

magic table is concept of triggers. when trigger perform the
insert,delete and update action on the table. the create a
temprory table that is called the magic table. when perform
dalete action:-- all deleted row stored in to a table
thease table is called "Deleted table" such that insert
action: create "created table" these table called the magic
table.

when trigger commited the magic table automatically deleted.
it is stored in Temp database of sql server.



i hope any person gotted.

Is This Answer Correct ?    25 Yes 0 No

Where are magic tables stored ? Is it in the same database where it is created ?..

Answer / amitmca09

Magic tables stored in the same database

Is This Answer Correct ?    19 Yes 4 No

Where are magic tables stored ? Is it in the same database where it is created ?..

Answer / raja

At the time of creating triggers magic tables will be created.

Is This Answer Correct ?    9 Yes 2 No

Where are magic tables stored ? Is it in the same database where it is created ?..

Answer / digvijay kumar singh

yes, magic table stored in current databse.

Is This Answer Correct ?    8 Yes 2 No

Post New Answer

More SQL Server Interview Questions

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

What is lookup override?

0 Answers   Informatica,

Differentiate between truncate vs delete in mssql?

0 Answers  

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

what is IDE,DMV in sql server?

1 Answers   Value Labs,

What is an execution plan? When would you use it?

0 Answers  

What is the new security features added in sql server 2014? : sql server security

0 Answers  

What is side by side migration in sql server?

0 Answers  

What is the purpose of the master database?

0 Answers  

What is dynamic cursor in SQL SERVER?

0 Answers  

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

For more SQL Server Interview Questions Click Here
Categories