in operator returns the condition satisfied rows only But in exists oper

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

Question Posted / raja

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

Please Help Members By Posting Answers For Below Questions

How to use subqueries with the in operators in ms sql server?

1084

What is SQL Azure Federations?

112

How to list all user defined functions in the current database?

1055

Is sql server free?

923

Where the sql logs gets stored? : sql server database administration

975

How many levels of sp nesting is possible?

1062

Please illustrate physical database architecture? : SQL Server Architecture

993

What are the methods used to protect against sql injection attack?

1074

Explain Geography datatype in SQL Server

1143

Explain the ways to controlling cursor behavior?

924

What are built in functions?

1028

What is query cost in sql server?

1000

What is implicit cursors?

1090

How do you start single user mode in clustered installations?

950

Explain how to maintain a fill factor in existing indexes?

1000