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  

---

Define constraints and give an example of their use?

0 Answers  

---

What is temporary stored procedure?

0 Answers  

---

What are the various editions of sql server 2017 that are available in the market?

0 Answers  

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

---

---

Explain what is lock escalation?

0 Answers  

---

What are subqueries in sql server?

0 Answers  

---

Explain what are the events recorded in a transaction log?

0 Answers  

---

Why use “in” clause in sql server?

0 Answers  

---

Do you know what is a linked server in sql server?

0 Answers  

---

How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  

---

How to test a dml trigger in ms sql server?

0 Answers  

---