What is filtered index?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

What are commit and rollback in sql?

0 Answers  

---

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

---

How will you know when statistics on a table are obsolete?

0 Answers  

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

Write an sql query for deleting duplicate rows?

0 Answers  

---

List the different types of collation sensitivities in sql server?

0 Answers  

---

What is factless fact table? : sql server analysis services, ssas

0 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

---