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 are the new security features added in sql server 2012? : sql server security
What are page splits? : SQL Server Architecture
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What happens on checkpoint?
What is the use of @@spid?
What is data block and how to define data block size?
what are the important architecture components of SSRS?
what are the types of indexes? : Sql server database administration
What is indexing in sql server with example?
how to determine the service pack currently installed on sql server? : Sql server database administration
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is meant by dirty read?
Explain the flow of creating a cube? : sql server analysis services, ssas
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is collation sensitivity?