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 unpivot?

1075

What is a benefit of using an after insert trigger over using a before insert trigger?

1034

Can sql server 2016 run on windows 7?

965

How to use go command in "sqlcmd"?

1267

What is an example of a foreign key?

1033

How to find the second highest salary of an employee?

1223

Working with TLogs

1896

What is RAID? What are the different types of RAID configurations?

1182

What is indexed view?

1026

How each E-R model constructs can be mapped to the relational model?

1051

What are the advantages of paper records?

1013

Does a full backup include transaction log?

1051

What are the properties of sub-query?

1133

What is bit data type?

1082

What are sub reports?

208