Answer / soma shaw

A cross join is a Cartesian join. for sets of A and B rows, you'll get a result of A * B rows. A full join will match all possible rows, meaning it will return AT MOST A + B rows.

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

0 Answers  

---

What is analysis service repository?

0 Answers  

---

How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,

---

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 Answers  

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---

Can you explain the role of each service?

1 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

---

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 active/passive and active/active cluster configurations?

0 Answers  

---

Which tcl commands are available on the sql server?

0 Answers  

---