Answer Posted / chitram

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

How to create a large table with random data for index testing in ms sql server?

999

---

How to set the current database in ms sql server?

1033

---

How to implement service broker?

948

---

What will happen if a column containing char type data is changed to the nchar data type?

1062

---

Can you always create a cache of a report?

160

---

What is the difference between createstatement and preparedstatement?

906

---

What are the results of running this script?

881

---

How to install sql server 2005 express edition?

1070

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1079

---

How to receive output values from stored procedures?

1087

---

What is an expression in ms sql server?

1032

---

What is temporal table?

839

---

What is code near application topology?

275

---

What is resource governor?

936

---

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1002

---