Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and EXISTS operators in
SQL Server?
- 9 Answers
- 67179 Views
- ASD Lab, CSC, Intelligroup, I also Faced
- E-Mail Answers
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
Where sql server usernames and passwords are stored in a sql server?
What are the different types of subquery?
What are pessimistic lock and optimistic lock?
What happens if the update subquery returns no rows in ms sql server?
What is correlated subquery in sql server?
How can we solve concurrency problems?
How is sql server used?
How to create percentile function?
How to download and install microsoft .net framework version 2.0?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is the template in sql?
How to add more data to the testing table in ms sql server?
How to disable stored procedure sql server?
What is difference between rownum and rowid?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
