1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / saiteja

Answer Posted / saiteja

there is no difference among them.

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the restrictions while creating batches in sql server?

587

Describe how to use linked server?

548

What are the functions in sql server?

549

What is the difference between dataadapter and datareader?

543

What are the advantages to use stored procedures?

573




Can we perform backup restore operation on tempdb?

571

query processing

1741

What are the lambda triggers?

489

What are the source of constraints?

512

What are page splits? : SQL Server Architecture

544

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

532

What is sql server schema compare? How we can compare two database schemas?

566

What are dml (data manipulation language) statements in ms sql server?

556

How to set database to be read_only in ms sql server?

554

How to encrypt Strored Procedure in SQL SERVER?

560