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 is the openxml statement in sql server?
How to use old values to define new values in update statements in ms sql server?
What is a subquery in a select query statement in ms sql server?
Write a SQL command to insert and update only a particular field?
whats new about truncate in sql server 2008?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
in the physical file layout, where should the transaction log be stored in relation to the data file?
Is the order of columns in the set clause important in ms sql server?
How can you stop stored procedures from recompiling?
What are the advantages of partitioning?
What is the difference function and stored procedure?
Do you know nested transaction?
What is the use of floor function in sql server?
Explain about remote stored procedure?
What do you mean by data manipulation language?