Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3428 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
How will you know when statistics on a table are obsolete?
What is 'Join' and explain its various types.
Explain the difference between clustered and non-clustered index?
how you can move data or databases between servers and databases in sql server? : Sql server administration
how many no of arguments can be passed in procedures and functions
Can we use trigger new in before insert?
Can sql servers link to other servers?
Give me a SQL Query to find out the second largest company?
Write a query for primary key constraint with identity key word?
What are the basic functions for master, msdb, model, tempdb databases?
How to add additional conditions in SQL?
What is the current limitation of the size of SQL Azure DB?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Define inner join in sql server joins?
