Sybase Technical Library - Product Manuals Home

Return to Collection List
Enable Frames

[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Table of contents for Transact-SQL User's Guide

Transact-SQL® User's Guide
About This Book
[+] Chapter 1 SQL Building Blocks
[+] Chapter 2 Queries: Selecting Data from a Table
[+] Chapter 3 Using Aggregates, Grouping, and Sorting
[+] Chapter 4 Joins: Retrieving Data from Several Tables
[+] Chapter 5 Subqueries: Using Queries Within Other Queries
[+] Chapter 6 Using and Creating Datatypes
[+] Chapter 7 Creating Databases and Tables
[+] Chapter 8 Adding, Changing, and Deleting Data
[+] Chapter 9 Views: Limiting Access to Data
[+] Chapter 10 Using the Built-In Functions in Queries
[+] Chapter 11 Creating Indexes on Tables
[+] Chapter 12 Defining Defaults and Rules for Data
[+] Chapter 13 Using Batches and Control-of-Flow Language
[+] Chapter 14 Using Stored Procedures
[+] Chapter 15 Using Extended Stored Procedures
[+] Chapter 16 Triggers: Enforcing Referential Integrity
[+] Chapter 17 Cursors: Accessing Data Row by Row
[-] Chapter 18 Transactions: Maintaining Data Consistency and Recovery
[+] How transactions work
[+] Using transactions
[-] Selecting the transaction mode and isolation level
[+] Choosing a transaction mode
[+] Choosing an isolation level
Compliance with SQL standards
[+] Using the lock table command to improve performance
Using the wait/nowait options of the lock table command
[+] Using transactions in stored procedures and triggers
Using cursors in transactions
Issues to consider when using transactions
Backup and recovery of transactions
[+] Chapter 19 Locking Commands and Options
[+] Appendix A The pubs2 Database
[+] Appendix B The pubs3 Database