Chapter 9 SQL Statements
409
For transactions starting with a BEGIN TRANSACTION statement,
@@trancount has a value of 1 in both Adaptive Server Anywhere and
Adaptive Server Enterprise after the first BEGIN TRANSACTION
statement. If a transaction is implicitly started with a different statement, and
a BEGIN TRANSACTION statement is then executed, @@trancount has a
value of 1 in Adaptive Server Anywhere, and a value of 2 in Adaptive Server
Enterprise after the BEGIN TRANSACTION statement.