hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

How to find the list of fixed hard drive and free space on server?

0 Answers  

---

Why do we use non clustered index?

0 Answers  

---

Explain the creation and execution of a user-defined function in the sql server?

0 Answers  

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

Is port 1433 secure?

0 Answers  

---

What is a trace frag?

0 Answers  

---

How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

1 Answers   GE,

---