What is the difference between IN and EXISTS operators in
SQL Server?
Answer Posted / arslan
the basic difference between in and exists
let's take the example of for loop in c++ and in loops when you write break statement it will iterates until the condition of break statement will true this like exist and in
if you didn't put break in it then it will execute the whole loop
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What type of locking occurs during the snapshot generation? : sql server replication
What is openrowset sql server?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are the types of dml?
What are approximate numeric data types in ms sql server?
where can you add custom error messages to sql server? : Sql server administration
What is intellisense?
Explain the concept of view and Types of views in SQL server?
Can you leave a union at any time?
What do you mean by the term 'normalization'?
How to get all stored procedures in sql server?
When would you use sql joins?
Which are the third-party tools used in sql server and why would you use them?
How to create a user to access a database in ms sql server using "create user" statements?