Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What would be your preference to use global or local temp table in store procedure and why?

user-image
Question added by Atiqul Islam , Sr Software Engineer , Prism Informatics Ltd
Date Posted: 2017/03/28
Anas Al-Sayed
by Anas Al-Sayed , System Analyst , Mencom Group

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

 

Neeraj Jha
by Neeraj Jha , .Net Developer , MRM

I mostly use use local temp table but if i need to access all the connections of sql then i use global temporary table.

Muhammad Jawad
by Muhammad Jawad , Deputy Manager (MIS) , AL-NOOR GROUP MDF BOARD

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. 

More Questions Like This