Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 4875 Views
- Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the New in SQL server 2008?
Explain Geometry datatype in sql server 2008 with example
What is meant by referential integrity?
What is a hint?
What is the stuff and how does it differ from the replace function?
What do mean by xml datatype?
What is attribute hierarchy? : sql server analysis services, ssas
What is trigger explain with program?
What is bit data type? What's the information that can be stored inside a bit column?
What is subquery? Explain the properties of a subquery?
What is the purpose of object explorer and its features? : sql server management studio
What does sql server mean?
How to change a login name in ms sql server?
How can you append an identity column to a temporary table?
What is relationship? What number of sorts of relationship are there?
