What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

How to generate create function script on an existing function?

0 Answers  

---

what is cluster and nin-cluster index?

4 Answers  

---

What is the maximum number of index per table?

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 the difference between seek predicate and predicate?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

What is rtm version in sql server?

0 Answers  

---

What is the advantage of sql server?

0 Answers  

---

What are subqueries in sql server?

0 Answers  

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

How to enable tcp/ip protocol on a sql server?

0 Answers  

---