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
How do you trace the traffic hitting a sql server?
What is normalization process?
What is join query?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is update locks?
Explain optimistic and pessimistic concurrency?
What is used to replicate sessions between instances in coldfusion clusters?
What is msdb database? : SQL Server Architecture
Why truncate is ddl?
What are three major types of constraints?
What is data compression?
What happens if date-only values are provided as date and time literals?
What is difference between standardization and normalization?
What is catalog views?
What are cursors in ms sql server?