Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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


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

What are trace flags?

0 Answers  

What is an entity-relationship diagram (erd)?

0 Answers  

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

What is default constraint in ms sql server?

0 Answers  

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

What is efficiency data?

0 Answers  

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

What are truncate options available in sql server? : sql server database administration

0 Answers  

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

Explain the concepts and capabilities of sql server?

0 Answers  

Explain use of expression builder.

0 Answers  

How to execute a sql statement using mssql_query()?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories