Answer Posted / chitram

select e1.sname,e2.sname from emp e1,emp e2 where e1.sname
= 'ram'
and e2.sname = 'raj';

How to use union to merge outputs from two queries together in ms sql server?

566

---

What is indexed view? How to create it?

603

---

Which sql server table is used to hold the stored procedure scripts?

624

---

How to use go command in "sqlcmd"?

652

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

608

---

---

What is the tcp/ip port on which sql server runs?

574

---

What is nonclustered index with included columns ?

558

---

Does sql server use t sql?

540

---

Do you know what is xpath?

563

---

What are the reporting services components?

92

---

How to create an inline table-valued function?

542

---

How to delete duplicate rows in sql server?

585

---

What are the types of sql server?

529

---

How do I view a stored procedure in sql server query?

542

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

582

---