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

What is the difference between local table and global table

Question Posted / sneha


What is the difference between local table and global table..

Answer / radha

A local temporary table exists only for the duration of a
connection or, if defined inside a compound statement, for
the duration of the compound statement.

A global temporary table remains in the database
permanently, but the rows exist only within a given
connection. When connection is closed, the data in the
global temporary table disappears. However, the table
definition remains with the database for access when
database is opened next time.

Is This Answer Correct ?    17 Yes 7 No

Post New Answer

More SQL Server Interview Questions

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

Can we drop user if user mapped to any logins

1 Answers  

Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,

What is a fill factor?

0 Answers  

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

What are the different types of subquery?

0 Answers  

How to send email from database?

0 Answers  

When do u use clustered index and non-clustered index?

3 Answers   IBM,

What is self contained scalar sub query?

0 Answers  

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers  

Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

What is the fillfactor concept in indexes?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories