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
Can you explain what are various ways to enhance the ssrs report?
How to add more data to the testing table in ms sql server?
what is a self join? Explain it with an example? : Sql server database administration
Explain about merge replications?
What are data driven subscriptions?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
How to enable/disable indexes?
Call by value and call by reference in procedure and function, with NOCOPY.
How do you create a data source?
What is 1nf normalization form?
What is key attribute?
how you can list all the tables in a database?
Explain the steps needed to create a scheduled job?
What is 2nf example?
Does sql server 2000 clustering support load balancing?