Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and EXISTS operators in
SQL Server?
- 9 Answers
- 67235 Views
- ASD Lab, CSC, Intelligroup, I also Faced
- E-Mail Answers
Answer Posted / navneet sharma
IN work like a OR in sql query but in is faster than OR in
case of IN server will search whole table
EXISTS is use to find the required row and does not search
whole table
| Is This Answer Correct ? | 29 Yes | 16 No |
Post New Answer View All Answers
Can we install sql server 2016 on windows 7?
How to return the top 5 rows from a select query in ms sql server?
What is 2nf normalization form?
What is a transaction and why is it important?
What is merge statement?
How to assign null values to variables or columns?
What do you mean by authentication modes in sql server?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
How to download microsoft sql server 2005 express edition?
Do you think BCNF is better than 2NF & 3NF? Why?
What is report snapshot?
What are rows and columns?
Which table keeps the locking information?
what is a live lock? : Sql server database administration
What is the importance of concurrency control?
