How you can change a cross join into an inner join?

0 Answers  

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---

How can I tell if sql server is 32 or 64 bit?

0 Answers  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

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,

---

---

What is temporal table?

0 Answers  

---

What is history table in sql server?

0 Answers  

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

What are the aggregate and scalar functions?

0 Answers  

---

Explain about SQL server 2005?

0 Answers  

---

Why do we need normalization?

0 Answers  

---