How to Check Whether a Global Temporary Exists in a SQL
Database or not?

Answer Posted / ish

use tempdb

sp_tables '##%'

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what type of index will get created after executing the above statement? : Sql server database administration

724


What is the difference between an index and a unique index?

739


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

702


What is the difference between rank and dense_rank?

682


What are translations and its use? : sql server analysis services, ssas

796






What is a select query statement in ms sql server?

760


How would you use user_constraints table in DB?

750


how to determine the service pack currently installed on sql server? : Sql server database administration

737


What are the recovery models for a database?

812


How to find the list of fixed hard drive and free space on server?

782


How to access the inserted record of an event?

772


Difference between Inner vs outer joins?

692


How fixed length strings are truncated and padded?

721


How do I create a stored procedure in sql server?

690


What are the kinds of subquery?

710