Register now or log in to join your professional community.
I use Variable Table, but if I want use temp table usually use local, because I need it only for one session.
Usually I use temp table to put some query result for session, that mean the other session they will have deferent result .
That is the reason
I mostly use use local temp table but if i need to access all the connections of sql then i use global temporary table.
I always use local temp table because in global you must have unique name and in local this is not neccessary because it creates table with in a session.