Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21847 Views
- Adsys, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / mohan
both are same
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Explain the commands in sql server?
What is the stored procedure?
How do you Implement SSIS Packages in your Project?
What is the difference between DataRow.Delete() and DataRow.Remove()?
How to test values returned by a subquery with the in operator?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Can you explain about buffer cash and log cache in sql server?
Name 3 ways to get an accurate count of the number of records in a table?
What objects does the fn_my_permissions function reports on? : sql server security
Explain primary key?
what are the different types of replication you can set up in sql server? : Sql server database administration
Why and when do stored procedure recompile?
Explain what is sql server english query?
What is tablesample?
