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 is the native system stored procedure to execute a command against all databases?

1017

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1001

How many types of local tables are there in sql server?

922

How do you drop an index?

915

what is memory-optimized nonclustered indexes

1013

What is cached report?

143

How do use Having,Group by,Group function in SQL?

1735

Why do we use non clustered index?

1075

What is usually the first word in a sql query?

1125

Can coalesce return null?

1002

How many instances per computer are there in sql server 2000?

1058

Explain forward - only cursors?

1049

What is join query?

879

Explain different types of collation sensitivity?

973

Explain about protocol layer present in SQL server?

1190