Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

Question Posted / swaraj

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

What is snapshot parameter in ssrs?

151

Can foreign key be deleted?

930

What is the use of sql profiler in sql server 2012?

904

What is the downside of using udf?

1113

What are the kinds of subquery?

1010

What is resultset concur_updatable?

1023

Where sql server user names and passwords are stored in sql server? : sql server database administration

1062

What is difference between joins and subqueries?

1125

How to declare and use cursor variables?

1176

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1142

Name few endpoints exposed by ssrs 2012?

357

What is replication and database mirroring?

1052

Can we use pragma autonomous_transaction in trigger?

963

Differentiate between a primary key and a unique key.

1076

What is primary key and example?

963