@@TRANCOUNT

Returns the number of BEGIN TRANSACTION statements that have occurred on the current connection. Can be 0 or 1 in Querona.

Syntax

@@TRANCOUNT

Return types

int

Example

SELECT @@TRANCOUNT as TransactionCount;

See Also