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,

---

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

0 Answers  

---

What is a collation in ms sql server?

0 Answers  

---

How will u get 5 years back record?

5 Answers  

---

Explain transaction server auto commit?

0 Answers  

---

---

What is the difference between resultset and resultsetmetadata?

0 Answers  

---

Explain how to send email from sql database?

0 Answers  

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---

What does truncate do?

0 Answers  

---

Why transaction is important?

0 Answers  

---