Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Atiqul Islam , Sr Software Engineer , Prism Informatics Ltd
Date de publication: 2017/03/28
Anas Al-Sayed
par 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
par 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
par 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