Home » Interview Q & A » Q4. What is the difference and similarities between local temporary table and global temporary table?

Q4. What is the difference and similarities between local temporary table and global temporary table?

Our Categories

Blog Stats

  • 32,852 hits

Calendar

May 2013
M T W T F S S
« Apr   Jun »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Please visit SQLVERSITY.COM for more details.

Local Temporary tables:

                Ex: CREATE TABLE dbo.#LocalTemp…..

 Global Temporary tables:

                Ex: CREATE TABLE dbo.##GlobalTemp…..

 Similarities:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: