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

What is the cartesian product of the table?

0 Answers  

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

0 Answers   HCL,

What is an index in a database?

0 Answers  

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

What is transact-sql language?

0 Answers  




How to create a new table in a given schema?

0 Answers  

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

What is nolock?

0 Answers  

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

what is Equity join?

2 Answers   ADP,

What is the maximum size of column in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories