rahul sharma
What is difference between global temporary tables and local temporary tables?
Posted by rahul sharma in .NET 4.5 on Nov 21, 2012
  • 0
  • 1
  • 1054
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.


PRIVACY POLICY | TERMS & CONDITIONS | SITEMAP | CONTACT US | ABOUT US | REPORT ABUSE
2014© C# Corner. All contents are copyright of their authors.