If i have one transaction say mainTransaction, within this mainTransaction i ha

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

1 Answers
4823 Views
Ness Technologies, I also Faced
E-Mail Answers

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

Explain the relational database management system (rdbms)?

0 Answers

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers Apple,

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers

What are four major operators that can be used to combine conditions on a where clause?

0 Answers

How to generate create function script on an existing function?

0 Answers

Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers

what is difference between having and where clause ?

3 Answers

What is database replication?

0 Answers

How to store pdf file in sql server?