Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Choosing an isolation level [Table of Contents] Using the lock table command to improve performance

Transact-SQL User's Guide

[-] Chapter 18 Transactions: Maintaining Data Consistency and Recovery
[-] Selecting the transaction mode and isolation level
[-] Compliance with SQL standards

Compliance with SQL standards

To get transactions that comply with SQL standards, you must set the chained and transaction isolation level 3 options at the beginning of every application that changes the mode and isolation level for subsequent transactions. If your application uses cursors, you must also set the close on endtran option. These options are described in Using cursors in transactions on page .

Choosing an isolation level [Table of Contents] Using the lock table command to improve performance