rahul sharma
What is difference between global temporary tables and local temporary tables?
Posted by rahul sharma in .NET 2015 on Nov 21, 2012
  • 0
  • 1
  • 1714
Do you know the answer for this question? Post it below.
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.