Differentiate between a having clause and a where clause.

0 Answers  

---

How to write a query with an inner join in ms sql server?

0 Answers  

---

What is an index?

8 Answers   Yardi Software,

---

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,

---

Explain full-text indexing?

0 Answers  

---

What are scheduled tasks in sql server?

0 Answers  

---

What happens if null values are involved in arithmetic operations?

0 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

What is apply operator in sql?

0 Answers  

---

Why the trigger fires multiple times in single login?

0 Answers  

---

Explain the functionalities that views support?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---