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
  • 1152
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.


Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS

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