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,

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---

How do you check sql server is up and running?

0 Answers  

---

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

Do you know how to store and query spatial data?

0 Answers  

---

What is bcp? When does it used?

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

What are the two types of concurrency?

4 Answers  

---

What do you mean by sql server 2005 express management tools?

0 Answers  

---

What is a covered index?

0 Answers  

---