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."

What is report server project?

133

---

Mention the different authentication modes in sql server.

957

---

between cast and convert which function would you prefer and why?

914

---

Describe in brief databases and sql server databases architecture.

939

---

What are the new features in sql server 2016?

926

---

What different steps will a sql server developer take to secure sql server?

927

---

What is reference section?

937

---

What is a performance monitor?

916

---

What do you know about system database? : SQL Server Architecture

924

---

What is ms sql server service broker?

929

---

What are partitioned views?

935

---

What is ssl in sql server?

1010

---

what is hash nonclustered index

906

---

What do you understand by mirroring?

951

---

Explain time data type in sal server 2008?

869

---