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

Is it possible for a stored procedure to call itself or recursive stored procedure?

891

Do you know what is fill factor and pad index?

940

Explain tables in SQL Azure?

120

How do I find query history in sql server?

873

What does man by sql wildcard characters in sql server?

991

What is the difference between primary key and unique constraints?

899

How to write a query with a left outer join in ms sql server?

924

what is the difference between Delete and Truncate command in SQL

1083

Where are sql server user names and passwords stored in sql server?

1014

Does table partitioning improve performance?

899

Explain the concepts and capabilities of sql server?

922

What are truncate options available in sql server? : sql server database administration

965

Explain different forms of normalization?

884

explain different types of backups avaialabe in sql server? : Sql server database administration

919

What is inline variable assignment?

974