IN: Returns true if a specified value matches any value in a sub-query

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

Question Posted / pranab

Answer Posted / pranab

IN:

Returns true if a specified value matches any value in a
sub-query or a list.

Exists:

Returns true if a sub-query contains any rows.

Is This Answer Correct ?

27 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What are user defined functions in ms sql server?

1063

Using the customer, and order table in northwind database, please write a query to produce xml?

1116

What is the difference between Triggers and Stored Procedure?

1152

explain databases and sql server databases architecture? : Sql server database administration

1012

What is service broker?

1061

What are the advantages of using stored procedures?

1004

Why do we use functions?

956

What is cross join in sql server joins?

1199

How can you set the threshold at which sql server will generate keysets asynchronously?

1050

what are user defined datatypes? : Sql server database administration

1014

What is ms sql server triggers?

1070

how to determine the service pack currently installed on sql server? : Sql server database administration

1025

What programming language would you use to create embedded functions in ssrs?

191

What is function of CUBE ?

1076

How to name query output columns in ms sql server?

1013