ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Atiqul Islam , Sr Software Engineer , Prism Informatics Ltd
تاريخ النشر: 2017/03/28
Anas Al-Sayed
من قبل 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
من قبل 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
من قبل 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. 

المزيد من الأسئلة المماثلة