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,

---

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

Can you type more than one query in the query editor screen at the same time?

0 Answers  

---

What is the maximum number of index per table?

0 Answers  

---

What are the 3 types of schema?

0 Answers  

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

Where cross join is used?

0 Answers  

---

Describe how to use the linked server?

0 Answers  

---