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

What is the difference between IN and EXISTS operators in
SQL Server?

Answer Posted / navneet sharma

IN work like a OR in sql query but in is faster than OR in
case of IN server will search whole table
EXISTS is use to find the required row and does not search
whole table

Is This Answer Correct ?    29 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between char and varchar2 datatype in sql?

1124


What is sql server query analyzer?

1102


Difference between aggregate functions of sql?

1148


Which joins are sql server default?

1071


What is the most common trace flags used with sql server?

1119


What number sorts of privileges are accessible in sql?

1088


What are the components of dbms?

997


Write an sql query to find first weekday of the month?

976


Can I save my report as html, excel or word? : sql server management studio

1013


Explain about SQLOS?

1060


What is difference between view and materialized view?

987


What is the difference between for xml raw and for xml auto?

1081


Can we use custom code in ssrs?

1166


What is row_number function?

1058


What is sub query and its properties?

1025