Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN and EXISTS operators in
SQL Server?
- 9 Answers
- 67564 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
Define views.
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How to provide column names in insert statements in ms sql server?
How to backup SQL Server Reporting Services ?
Can we perform backup restore operation on tempdb? : sql server database administration
Are resultset updatable?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
How to create and drop temp table in sql server?
How to drop an existing stored procedure in ms sql server?
how to control the amount of free space in your index pages? : Sql server database administration
what is the difference between Tabular and Matrix report?
What is server-level principal?
What is row_number () and partition by in sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is the rdl file?
