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 difference between the application object and session object?

1068

how can u get last observation in an unknown dataset ?

2436

How do you handle datasets larger than 50 gb?

162

What is the use of stored procedure?

940

Can we shrink data file in sql server?

1049

What are trace flags and mention a few common trace flags used with sql server?

1087

What are key constraints?

976

Can We Use Data-grids For Our Report In Ssrs?

184

What are the database roles? : sql server security

1188

What is store procedure? How do they work? When do you use?

942

What are the restrictions that views have to follow?

972

Can we add our custom code in ssis?

988

Why we need sql server?

965

What is the difference between a view and a stored procedure?

1037

What stored by the msdb?

1000