Previous Topic

Next Topic

Inhoudsopgave

Book Index
Commit Without Begin Tran

In ASE you can issue a commit statement without a corresponding ‘begin tran’ statement. In MS SQL Server this is not possible.

Example

declare @c char(10)

commit

In MS SQL Server, use the following code instead:

declare @c char(10)

if @@TranCount > 0 commit