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...

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 ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to apply filtering criteria at group level with the having clause in ms sql server?

1007


How sql server executes a statement with nested subqueries?

1038


Create and insert into temp table in sql server?

1040


Do you have any idea about the tcl commands?

971


Explain trigger classes i.e. Instead of and after trigger?

884


What is the difference between index seek vs. Index scan?

1029


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5932


How to convert numeric expression data types by assignment operations?

1094


Is it possible to replicate data from sql server to oracle? : sql server replication

1098


What is an example of a foreign key?

984


Explain the steps to create and execute a user-defined function in the sql server?

980


Explain about system stored procedure?

1041


What Is Rdbms?

1169


What is merge join?

1202


How each E-R model constructs can be mapped to the relational model?

1015