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,

---

How many types of the database links?

0 Answers   MCN Solutions,

---

explain the type of contraints

3 Answers  

---

Explain the benefits of user-defined functions?

0 Answers  

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

---

what protocol both networks use? : Sql server database administration

0 Answers  

---

What are the disadvantages of using querystrings to send data from one page to another?

0 Answers  

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---

Can two tables share the same primary key?

0 Answers  

---

what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

What are the benefits of filtered indexes?

0 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---