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 the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

---

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,

---

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

2 Answers   TCS,

---

What number sorts of privileges are accessible in sql?

0 Answers  

---

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  

---

What does the not null constraint do?

0 Answers  

---

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

---

What is a view?

6 Answers  

---

Explain candidate key, alternate key, and composite key?

0 Answers  

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

How to find Duplicate Records In table?

0 Answers   HCL,

---