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 compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1154

What are the types of table?

1031

What is the process of normalising?

1047

How to modify the underlying query of an existing view?

1030

How to rename databases in ms sql server?

1260

What is snapshot report?

172

What is the difference between dropping a database and taking a database offline?

1218

What is multilevel indexing?

981

Explain what is meant by replication of database?

1106

How to get the definition of a trigger back?

1045

Why normalization is used?

1069

How to reaname table name without using sp_Rename in sql server..?

1039

What is a sql join?

1082

Can we return Data from 4(more than 1) tables in stored procedure?

1109

What is hot add cpu in sql server 2008?

984