Answer Posted / ram&saran

It's possible, up to 32 levels of transaction in sql server2005.
begin tran t1
----statements
begin tran t2
----statments
.
.
commit tran t2
commit tran t1

Does group by or order by come first?

900

---

What do you mean by table and field in sql?

966

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1146

---

What do you understand by sql server agent?

906

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

882

---

Is it possible to update the views? If yes, how, if not, why?

970

---

What is query optimizer in sql server?

957

---

What are the new features of sql server 2008 r2 reporting service?

193

---

What is the difference between char and varchar2 datatype in sql?

1007

---

Is port 1433 secure?

931

---

What is the difference between stored procedure and user defined functions?

1128

---

Explain raiserror in sql server?

962

---

Is foreign key a primary key?

977

---

What is the correct order of the logical query processing phases?

874

---

What are the features of Embedded SQL

1076

---