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 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