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

What is lookup override?

957

what authentication modes does sql server support? : Sql server database administration

999

What is query and its types?

868

What does this statement do @@rowcount?

920

What is statement level trigger?

932

How to write a query with an inner join in ms sql server?

995

What are the ways available in sql server to execute sql statements?

1036

What is an identity column in insert statements?

964

What are date and time data types in ms sql server?

1013

What do you understand by recursive stored procedures?

937

Explain what is use of dbcc commands?

986

Which rendering formats are affected by the pagesize properties?

134

What is the xml datatype?

987

how would you troubleshoot blocking? : Sql server database administration

942

What are character string data types in ms sql server?

1138