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,

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

What is the maximum size of sql server database?

0 Answers  

---

i want table name basis on column name.

5 Answers  

---

Write a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

---

---

What is lock escalation and what is its purpose?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

Explain the commands in sql server?

0 Answers  

---

What is global temp table?

0 Answers  

---

how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  

---

Can sql servers link to other servers?

0 Answers  

---