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 are the main sources of data?

0 Answers  

---

What are the difference between “where” and “having” clause in sql server?

0 Answers  

---

What are different types of raid configurations? : SQL Server Architecture

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

Why can there be only one clustered index and not more than one?

0 Answers  

---

What is lock escalation?

1 Answers  

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

If user is owning any SQL Objects, can we drop that user

0 Answers  

---