Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and EXISTS operators in
SQL Server?
- 9 Answers
- 66811 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
List the different index configurations possible for a table?
What are the dis_advantages of stored procedures, triggers, indexes?
What is intellisense?
What is the contrast between sql and pl/sql?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
What are trace flags and mention a few common trace flags used with sql server?
How to divide query output into multiple groups with the group by clause in ms sql server?
How to use order by with union operators in ms sql server?
Explain what is lock escalation?
What are the differences between having and where clause.
Which sql server is best?
Mention what are the core components of ssrs?
What are the 7 disadvantages to a manual system?
How many replicas are maintained for each sql azure db?
What do you mean by sql server agent?
