IN Vs OR operator which is best to use sql server.

Answer Posted / swaraj

hi i am swaraj.
Ans:-

As per my opinion The IN operator is best B'coz
Due to IN operator at one time multipale requirtment
van satisfied
But Due to OR operator Only one requirtment get satisfied.
So IN operator is Good.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get a list all databases on the sql server?

579


Can you explain what are various ways to enhance the ssrs report?

581


What does ss stand for sexually?

578


Explain filtered indexes benefits?

593


What is the difference between a view and a stored procedure?

552






How to find out what is the default collation in a database?

621


What is oltp (online transaction processing)?

581


How do you migrate data from mssql server to azure?

151


What is store procedure? How do they work?

575


How to use copy and concatenate commands in SQL?

597


Explain what is raid and what are different types of raid levels?

530


What is the difference between primary key and unique constraints?

506


What is tempdb in sql server?

509


How to check parameter value in stored procedure sql server?

462


What are sub reports and how to create them?

99