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,

---

What are the general features of sql server management studio? : sql server management studio

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

---

Will count(column) include columns with null values in its count?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What is dynamic cursor in SQL SERVER?

0 Answers  

---

Explain what is scheduled job and how to create it?

0 Answers  

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

What structure can you implement for the database to speed up table reads?

0 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---