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 delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

What is the log shipping?

0 Answers  

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

Explain the various types of concurrency problem?

0 Answers  

---

How to update muliple row in single query?

0 Answers   MCN Solutions,

---

Explain contrast amongst grouped and non-bunched records?

0 Answers  

---

How to generate create view script on an existing view?

0 Answers  

---

What is a non clustered primary key?

0 Answers  

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

What are the advantages of policy management?

0 Answers  

---