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,

---

When would you use sql joins?

0 Answers  

---

What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

---

How many types of Joins in SQL Server 2005?

9 Answers   CarrizalSoft Technologies, HCL,

---

How to find the service pack installed? : sql server database administration

0 Answers  

---

How optimize sql query with multiple joins in sql server?

0 Answers  

---

Where the sql logs gets stored?

0 Answers  

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---

Do you know hot add cpu in sql server 2008?

0 Answers  

---