Answer / brahma

Yes,
Begin transaction t1
update <Table_Name> set <col1>=<col1>+50
Begin Transaction t2
delete from <Table_Name> set <col1>=<col1>+100
commit Transaction t2
end transaction t1

Answer / visala

yes, we can have nested transactions. to know the nest
level use @@trancount

Answer / swapna

Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK,
SAVE TRAN and @@TRANCOUNT.

Answer / 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

Is it possible to create trigger on views?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

---

Mention the differences between having and where clause.

0 Answers  

---

Where cross join is used?

0 Answers  

---

What is nonclustered index on computed columns?

0 Answers  

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

What are types of subqueries?

0 Answers  

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

---

What is difference between unique and primary key?

0 Answers  

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

---

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,

---