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,

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

0 Answers  

---

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

---

What is autocommit mode in sql server?

0 Answers  

---

Explain Active/Active and Active/Passive cluster configurations?

1 Answers  

---

List the different index configurations possible for a table?

0 Answers  

---

What is an indexed view?

0 Answers  

---

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,

---

How to check if a table is being used in sql server?

0 Answers  

---

What type of Index will get created after executing the above statement?

0 Answers  

---

What is the difference between a check constraint and a rule?

0 Answers  

---

how to overcome kernel isssues

0 Answers   Fortune,

---