Answer / guest

Checking whether a table exists in a Microsoft SQL Server
database is easy. You can use this query:

SELECT 'x'
FROM sysobjects
WHERE type = 'U' and NAME = 'mytable'
But this query will not work while searching for global
temporary tables. Global temporary tables are stored in tempdb.
Use this syntax for the search:

DECLARE @temp_table VARCHAR(100)
SET @temp_table = '##my_temp_table'
IF NOT EXISTS (SELECT 'x'
FROM tempdb..sysobjects
WHERE type = 'U' and NAME = @temp_table)
PRINT 'temp table ' + @temp_table + ' does not exist'

ELSE
PRINT 'temp table ' + @temp_table + ' exists.'
Note: You cannot search for local temporary tables (# prefix
tables) in this way. This is because SQL Server appends a
unique number to the name you supply. For example, if you
specified "#temp," the name in sysobjects would be something
like "#temp____1234."

Answer / ish

use tempdb

sp_tables '##%'

How to update values in a table with update statements in ms sql server?

0 Answers  

---

What are the type of Indexes? which one is best, why?

6 Answers  

---

How can I check if a view exists in a sql server database?

0 Answers  

---

How to populate a table in sql server?

0 Answers  

---

What is the difference between indexing and hashing?

0 Answers  

---

What is auditing in sql server?

0 Answers  

---

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  

---

What is a join and their types?

2 Answers   Challenger Financial,

---

Can you explain the disadvantages/limitation of the cursor?

0 Answers  

---

What is index fragmentation in ms sql server?

0 Answers  

---

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

---

Explain syntax for viewing trigger?

0 Answers  

---