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 you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

What is correlated subquery in sql server?

0 Answers  

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

what is package and it uses and how can u call a package

0 Answers   Satyam,

---

Explain DBMS, RDBMS?

6 Answers  

---

What is primary key index?

0 Answers  

---

How to define and use table alias names in ms sql server?

0 Answers  

---

How many full-text indexes can a table have?

0 Answers  

---

How can you know if the row fetched from cursor is still valid in underlying table?

0 Answers  

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

What is bcp? When does it use?

0 Answers  

---