Answer Posted / chitram

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

How to use values from other tables in update statements in ms sql server?

1184

---

Explain in details security in SQL azure?

123

---

How do I create a stored procedure in sql server?

1094

---

What is right outer join in sql server joins?

1216

---

How to delete existing rows in a table?

1246

---

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

1230

---

What are the different SQL Server Versions you have worked on?

1060

---

What is the full form of dql?

1024

---

What stored procedure would you use to view lock information?

1016

---

what are the three command line utilities and what are their primary functions?

153

---

what is isolation level at dead lock?

2209

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1110

---

How to remove duplicate rows from table?

1311

---

List the various tools available for performance tuning?

924

---

What are subquery and its properties?

1099

---