create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

What is difference between equi join and inner join?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

How to get the definition of a trigger back?

0 Answers  

---

---

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

What are temporal tables in sql server 2016?

0 Answers  

---

Why de-normalization required?

0 Answers  

---

Explain cursor as data base object?

0 Answers  

---

Do you know what are various aggregate functions that are available?

0 Answers  

---

what is difference between NULL and ISNULL in SQL Server 2008?

0 Answers   MCN Solutions,

---