rahul sharma
What is difference between global temporary tables and local temporary tables?
Posted by rahul sharma in .NET on Nov 21, 2012
  • 0
  • 1
  • 1397
Do you know the answer for this question? Post it below.
Guest
Posted by Irshad Ahmad on Feb 21, 2013
  • 0

1) denoted by # symbol.
2) valid for the current connection only.
They are cleared as soon as the curent connection closes.
3)cannot be shared between multiple users.

global:
1)denoted by ## symbol.
2)Available to all the connections once created.
They are cleared when the last connection is closed.
3)can be shared betwen multiple users.