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,

---

What is sql server locking?

0 Answers  

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

---

How to create Clustered Primary Key to table?

2 Answers  

---

ow to bring suspect mode datbase online from scratch

0 Answers  

---

---

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

---

How to drop existing views from a database in ms sql server?

0 Answers  

---

What is the difference between a local and a global variable?

5 Answers  

---

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

---

What are security principals used in sql server 2005?

0 Answers  

---

how can you move the master database

1 Answers   IBM,

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---