Please visit DEMANDDRAFT.SHOP for quality of products...

Ad

Search This Blog

Sunday, June 3, 2012

Difference between Local & Global Temporary tables

Local Temporary Tables:
Prefixed with Single pound sign(#).
Local Temporary tables are visible to that session of SQL Server which has created it.
Local Temporary Tables are automatically dropped.

Global Temporary Tables:

Prefixed with Single pound sign(##).
Local Temporary tables are visible to all session of SQL Server.
Global Temporary Tables are automatically dropped.


No comments:

Post a Comment