What is the difference between IN and EXISTS operators in
SQL Server?
Answer Posted / raja
in operator returns the condition satisfied rows only
But in exists operator if any condition satisfied it will returns all the rows.
| Is This Answer Correct ? | 6 Yes | 15 No |
Post New Answer View All Answers
What is default constraint?
How to copy data from one table to another table?
Which tools are available to manage SQL Azure databases and servers?
What are the security related catalog views? : sql server security
Difference between aggregate functions of sql?
How to list all tables in the database using odbc_tables()?
What is the sql case statement used for?
what is difference between NULL and ISNULL in SQL Server 2008?
What is database black box testing?
Why would you use sql agent?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What are different types of raid levels?
How to convert numeric expression data types using the cast() function?
State the difference between union and union all?
What is normalization of database? What are its benefits?