Set Transaction Isolation Level

In ASE you can use the ‘set transaction isolation level’ statement with either numerical or string constants. In MS SQL Server, only string constants are allowed.

ASE	MS SQL Server
0 \| read uncommitted	read uncommitted
1 \| read committed	read committed
2 \| repeatable read	repeatable read
	snapshot
3 \| serializable	serializable

Example

print 'Numeric isolation level'

set transaction isolation level 1

print 'String isolation level'

set transaction isolation level read committed