In ASE you can issue a rollback
statement without a corresponding ‘begin tran
’ statement. In MS SQL Server this is not possible.
Example
declare @c char(10)
rollback
In MS SQL Server, use the following code instead:
declare @c char(10)
if @@TranCount > 0 rollback