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 do you mean by SQL injection attack?

609


Can we use where clause in union?

588


What is log ldf?

550


What is clr ddl trigger?

543


What is ms sql server service broker?

506






What is query cost in sql server?

547


Why do we need different type of parameter?

548


What is ddl command?

525


Why do we use functions?

503


What is the difference between value type and reference type?

548


What is "scheduled jobs" or "scheduled tasks"?

551


What is the difference between clustered and a non-clustered index?

591


Do you know what is openxml in sql server?

610


What is sql server english query?

535


How to select some specific rows from a table in ms sql server?

563