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,

---

Explain full-text indexing?

0 Answers  

---

What is use of except clause? How it differs from not in clause?

0 Answers  

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

What is index in an assignment?

0 Answers  

---

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

What is cross join in sql server joins?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

Explain the truncate command? : SQL Server Architecture

0 Answers  

---

Magic Tables ?

2 Answers   Thomson Reuters,

---

How to use union to merge outputs from two queries together in ms sql server?

0 Answers  

---

What is the exact numeric data type in sql?

0 Answers  

---