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 '##%'

Explain what role entity and relationship play in an ER diagram.

0 Answers  

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---

What is the difference between a unique key and primary key?

0 Answers  

---

what is the main difference between after trigger and instead trigger.

2 Answers  

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

How many index keys possible for a table

6 Answers  

---

Explain different backup plans?

0 Answers  

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

What is data compression?

0 Answers  

---

What is purpose of normalization?

0 Answers  

---