13 February 2014

Difference between local and global temporary tables?

local:

1) denoted by # symbol. 
2) valid for the current connection only. 
They are cleared as soon as the current 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 between multiple users. 

Both of then are stored in the temp db database

No comments:

Post a Comment