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's the difference between delete table and truncate table commands? : Sql server database administration

967

How to locate and take substrings with charindex() and substring() functions?

1008

What is the query and subquery?

1070

Explain the architecture of ms sql reporting service?

912

What is the use of tempdb? What values does it hold?

1058

What is the return type of executeupdate ()?

896

What is entity data services?

1046

What is the difference between varchar and varchar types?

1064

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1008

What is tablesample?

1099

How do I uninstall sql server 2014?

925

What are the purposes of floor and sign functions?

964

Can we use max in where clause?

921

What is a trace frag?

1074

What is an indexed view?

949