I have scenario where data needs to be inserted into a temporary table in a stored procedure and this will be read from the calling program. Which temporary table do I need to use for this? Is it the created temporary table or declared global temporary table? Since the declared global temporary table doesn't have a catalog entry unlike the created global temp table is it possible to use that in these scenarios?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!