Previous Topic

Next Topic

Inhoudsopgave

Book Index

Rollback Without Begin Tran

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