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,

---

What is difference between commit and rollback when used in transactions?

0 Answers  

---

what is a live lock? : Sql server database administration

0 Answers  

---

Is index a datbase objects in sql server?

2 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---

---

What is catalog views?

0 Answers  

---

What is the sql server agent?

0 Answers  

---

What command is used to create a database in the sql server and how?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  

---

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

---

Can we shrink data file in sql server?

0 Answers  

---