declare @trans2 varchar(10)='transaction2' begin tra

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

Question Posted / vijayalakshmi

1 Answers
3333 Views
AllState, I also Faced
E-Mail Answers

Answer Posted / vijayalakshmi

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);
save transaction @trans2
commit transaction @trans2
rollback tran @trans2

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different types of collation sensitivity?

1055

How to create a new login name in ms sql server?

995

Explain different forms of normalization?

885

What are out-of-range errors with date and time literals?

965

Can you use order by when defining a view?

915

What is t-sql script to take database offline – take database online.

1022

explain the storage models of olap? : Sql server database administration

887

What is explicit cursors?

988

Is sql server free?

870

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1802

What is the difference between mysql and mysqli?

1083

What are the steps to insert a table?

892

What is log shipping?

911

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1115

How to convert character strings into numeric values?

1033