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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain what are various ways to enhance the ssrs report?

665


How to add more data to the testing table in ms sql server?

641


what is a self join? Explain it with an example? : Sql server database administration

573


Explain about merge replications?

677


What are data driven subscriptions?

85






What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

689


How to enable/disable indexes?

680


Call by value and call by reference in procedure and function, with NOCOPY.

952


How do you create a data source?

576


What is 1nf normalization form?

675


What is key attribute?

605


how you can list all the tables in a database?

629


Explain the steps needed to create a scheduled job?

583


What is 2nf example?

635


Does sql server 2000 clustering support load balancing?

656