Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK, SAVE TRAN and @@T

Can you have a nested transaction?

Question Posted / swapna

Answer Posted / swapna

Yes, very much. Check out BEGIN TRAN, COMMIT, ROLLBACK,
SAVE TRAN and @@TRANCOUNT.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is explicit mode in sql server?

1063

What is transaction server distributed transaction?

1056

Explain the various types of concurrency problem?

1196

What is code near application topology?

279

Explain trigger and trigger types?

987

What is the partitioning method?

1019

Explain optimistic and pessimistic concurrency?

994

What is default constraint?

1000

Do you know the isolation level that sql server support?

962

what is denormalization and when would you go for it? : Sql server database administration

1190

When a primary key constraint is included in a table, what other constraints does this imply?

989

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1049

What is the difference between rank and dense_rank?

1090

Can you leave a union at any time?

1063

How to convert a unicode strings to non-unicode strings?

1102