In the below query i have performed the commit transaction statement but still t

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 / shardha

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

In the below query i have performed the commit transaction statement but still the values after the ..

Answer / 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

More SQL Server Interview Questions

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers

What are cursors?

8 Answers

What is a data collection table?

0 Answers

what are the problems in logshipping?

3 Answers

What is the simplest way to create a new database in ms sql server?

0 Answers

How many non clustered indexes there can be on table ?

0 Answers

What are the disadvantages of using querystrings to send data from one page to another?

0 Answers

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers

Explain about service Broker functions?

0 Answers

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers Satyam,

System requirements for sql server 2005 express edition?

0 Answers

What are the types of joins in sql?

0 Answers

For more SQL Server Interview Questions Click Here