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 type of locking occurs during the snapshot generation? : sql server replication

1261

How many types of cursor type are there?

1011

How to access the inserted record of an event?

988

What is an expression in ms sql server?

1008

What is sql server english query?

1034

How to loop through result set objects using odbc_fetch_row()?

918

What are the characteristics of modern DBMS?

1029

What are the advantages of partitioning?

1042

Please explain go command in sql server?

990

How to enable/disable indexes?

1011

Name the different type of indexes in sql?

906

How to recover from sql injection? : sql server security

954

What is the purpose of object explorer and its features? : sql server management studio

1120

What are different types of replication in sql server?

1029

What is the difference between insensitive and scroll cursor?

1070