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

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

955


What type of locking occurs during the snapshot generation? : sql server replication

1262


What is openrowset sql server?

1061


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

882


What are the types of dml?

930


What are approximate numeric data types in ms sql server?

1004


where can you add custom error messages to sql server? : Sql server administration

1046


What is intellisense?

990


Explain the concept of view and Types of views in SQL server?

941


Can you leave a union at any time?

999


What do you mean by the term 'normalization'?

1127


How to get all stored procedures in sql server?

937


When would you use sql joins?

910


Which are the third-party tools used in sql server and why would you use them?

843


How to create a user to access a database in ms sql server using "create user" statements?

912