Answer Posted / 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."

State the difference between local and global temporary tables?

1109

---

Determine when to use stored procedure to complete sql server tasks?

1047

---

What are different types of data sources?

1006

---

Difference between primary key and clustered index?

998

---

Explain about unique identifier data type in sql server?

905

---

What is openrowset sql server?

1120

---

when would you go for denormalization? : Sql server database administration

861

---

Please differentiate between a local and a global temporary table?

997

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

975

---

What are sp_configure commands and set commands?

1016

---

How do users use Report Builder with SQL Server data sources?

154

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1114

---

List out the differences between global and local temp tables in sql server?

1049

---

Explain the steps needed to create a scheduled job?

917

---

How do I determine how many instances of sql server are installed on a computer?

999

---