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 find the date and time of last updated table?

6 Answers   Teledata,

---

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

What are constraints in microsoft sql server?

0 Answers  

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

Does a server store data?

0 Answers  

---

What is scrollable cursor?

0 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

What is the difference between a check constraint and a rule?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

How to add more data to the testing table in ms sql server?

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---