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 do I find my localdb version?

0 Answers  

---

Do you know what is replace and stuff function in sql server?

0 Answers  

---

What is self contained sub query?

0 Answers  

---

What are truncate options available in sql server? : sql server database administration

0 Answers  

---

How to update multiple rows with one update statement in ms sql server?

0 Answers  

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

What do you understand by sql server agent?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

How to make remote connection in database?

0 Answers  

---