Pages

Men

rh

6/03/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