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
what type of index will get created after executing the above statement? : Sql server database administration
What is the difference between an index and a unique index?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What is the difference between rank and dense_rank?
What are translations and its use? : sql server analysis services, ssas
What is a select query statement in ms sql server?
How would you use user_constraints table in DB?
how to determine the service pack currently installed on sql server? : Sql server database administration
What are the recovery models for a database?
How to find the list of fixed hard drive and free space on server?
How to access the inserted record of an event?
Difference between Inner vs outer joins?
How fixed length strings are truncated and padded?
How do I create a stored procedure in sql server?
What are the kinds of subquery?