Both are used for different purposes like... select * from table where d

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

Question Posted / sandeep rana

4 Answers
11625 Views
I also Faced
E-Mail Answers

Answer Posted / sandeep rana

Both are used for different purposes like...

select * from table where data in(1,2,3,4,5,6)

select * from table where data in(1,2,3,4,5,6) or data1
like('%s','%t')

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does it mean to invest in the index?

905

what are the different ways to return the rowcount of a table?

943

List the advantages of using stored procedures?

997

What have included columns when we talk about sql server indexing?

989

What is a dbms wizard?

968

Explain the microsoft sql server delete command? : SQL Server Architecture

1007

What is precedence constraint?

923

What is resultset concur_updatable?

969

What are the advantages of sql stored procedure?

1015

How do you send email on SQL Server?

999

Can we use custom code in ssrs?

1057

What is a fill factor?

1033

how to create “alternate row colour”?

142

how to control the amount of free space in your index pages? : Sql server database administration

982

Define inner join in sql server joins?

987