In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

how to get 25th row in any table in sqlserver can u tell me syntax

8 Answers  

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

What is the default Port No on which SQL Server listens?

0 Answers  

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

How column data types are determined in a view?

0 Answers  

---

What is transaction server consistency?

0 Answers  

---

What is the difference between executequery () and executeupdate ()?

0 Answers  

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

---