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

If i have one transaction say mainTransaction, within this
mainTransaction i have another two transaction say t1 and t2.
Now while execution t1 completes successfully and commit
statement fires, but while executing t2 some error occurs
and rollback statement fires.
What happen to t1, is it rollback or not?

Question Posted / brijen.patel


If i have one transaction say mainTransaction, within this mainTransaction i have another two trans..

Answer / candorz

BEGIN TRANSACTION
GO
BEGIN TRANSACTION
INSERT INTO [JSSKDB].[dbo].[JobsDb_Countries]
([CountryName])
VALUES
('something')
GO
COMMIT
GO
BEGIN TRANSACTION
INSERT INTO [JSSKDB].[dbo].[JobsDb_Countries]
([CountryName])
VALUES
('something1')
ROLLBACK
GO


For the above transaction the rollback will undo any changes made by the previous sub-transaction i.e. no change will be seen in the DB

Is This Answer Correct ?    7 Yes 1 No

Post New Answer

More SQL Server Interview Questions

If there is failure during updation of certain rows, what will be the state?

2 Answers  

Issues related in upgrading SQL Server 2000 to 2005 / 2008

0 Answers  

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

Explain some DBCC commands?

6 Answers  

What authentication modes does sql server support?

0 Answers  

How to define the name and server for a new dsn?

0 Answers  

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

How to create an multi-statement table-valued function?

0 Answers  

What do you mean by data integrity?

0 Answers  

what is web server?

3 Answers   Satyam,

Is null in sql server?

0 Answers  

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories