Answer / parnita

In pair wise comparison we write like this:"where (MGR_ID,
DEPT_ID) IN (SUBQUERY)"IN non pair wise comparison we write
like this:"where (MGR_ID) IN (SUBQUERY)and (DEPT_ID) IN
(SUBQUERY)"In first one we are checking two columns
simultaneously ...

Answer / taroon

See the thing is in pairwise comparison, we are taking the
columns which are of composite key type, so that the
comparisons will be very effective. But nonpairwise
comparisons are like multi_row subqueries with IN operator,
where we are checking single column values.

But the results will be different in both the cases. Just
try. If you want some examples regarding that, just do let
me know.

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

How do I partition a table in sql server?

0 Answers  

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

What is a join in sql?

0 Answers  

---

How can you find out how many rows returned in a cursor?

0 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---