2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?

1 Answers   IBM,

---

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

What is 1nf 2nf?

0 Answers  

---

what are cursors? : Sql server database administration

0 Answers  

---

What is the difference between set and select?

0 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

What is partitioned view?

0 Answers  

---

How to return the date part only from a sql server datetime datatype?

0 Answers  

---

Explain what are magic tables in sql server?

0 Answers  

---

Can you explain about buffer cash and log cache in sql server?

0 Answers  

---