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

in operator returns the condition satisfied rows only

But in exists operator if any condition satisfied it will returns all the rows.

Is This Answer Correct ?    6 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is default constraint?

1000


How to copy data from one table to another table?

996


Which tools are available to manage SQL Azure databases and servers?

115


What are the security related catalog views? : sql server security

950


Difference between aggregate functions of sql?

1105


How to list all tables in the database using odbc_tables()?

1052


What is the sql case statement used for?

1100


what is difference between NULL and ISNULL in SQL Server 2008?

1016


What is database black box testing?

1034


Why would you use sql agent?

1265


What are the basic functions for master, msdb, model, tempdb and resource databases?

988


What are different types of raid levels?

1170


How to convert numeric expression data types using the cast() function?

1069


State the difference between union and union all?

928


What is normalization of database? What are its benefits?

1028