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 / arslan

the basic difference between in and exists

let's take the example of for loop in c++ and in loops when you write break statement it will iterates until the condition of break statement will true this like exist and in
if you didn't put break in it then it will execute the whole loop

Is This Answer Correct ?    7 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you trace the traffic hitting a sql server?

1141


What is normalization process?

1175


What is join query?

893


What is the difference between dbcc indexdefrag and dbcc reindex?

987


What is update locks?

886


Explain optimistic and pessimistic concurrency?

993


What is used to replicate sessions between instances in coldfusion clusters?

1072


What is msdb database? : SQL Server Architecture

1130


Why truncate is ddl?

1088


What are three major types of constraints?

1116


What is data compression?

993


What happens if date-only values are provided as date and time literals?

1022


What is difference between standardization and normalization?

1101


What is catalog views?

1068


What are cursors in ms sql server?

1178