This book is a complete guide to Transact-SQL. It contains an introductory chapter, which gives an overview of SQL. The remaining chapters are divided into two main parts: Basic Concepts and Advanced Topics.

Chapter 1, "SQL Building Blocks," describes the naming conventions used by SQL and the enhancements (also known as extensions) added by Transact-SQL. It also includes a description of how to get started with Transact-SQL using the isql utility. Sybase recommends that all users read this chapter.

Table of Contents

Chapter 1—Overview of Client/Server
Chapter 2—Understanding the Sybase Client/Server Architecture
Chapter 3—Introduction to Transact-SQL
Chapter 4—Transact-SQL Datatypes
Chapter 5—Creating and Altering Database Objects
Chapter 6—Transact-SQL Programming Constructs
Chapter 7—Transact-SQL Program Structures
Chapter 8—Transaction Management
Part III—Performance and Tuning

Chapter 9—Defining Performance Expectations and Variables

Table of contents

# Database Design and Performance (Chapter 18)

# Concurrency Control in Distributed Databases

# Timestamp-Based Concurrency Control

# Understanding the Query Optimizer (Chapter 13)

# Designing Indexes for Performance (Chapter 12)

# Understanding SQL Server Storage Structures (Chapter 11)

# Defining Performance Expectations (Chapter 10)

# Transaction Management (Chapter 9)

Table of Contents:

Sybase Transact SQL Workshop
DDL Overview
Transact SQL Primer

Sybase Database Administration
Sybase DBA Tasks
Unix Scripts / Utilities

Sybase 12.5 Features
New! Sybase 15 Features

Sybase Concepts
Sybase Overview
Compared to Oracle
Adaptive Server Anywhere

To Download this E-Book Click Here.

Table of Contents

1. Introduction
2. What you will need
* A Web Server
* A Web Browser
* A Stored Procedure Editor
* Knowledge of HTML syntax
* Knowledge of writing stored procedures
* A Sybase account
3. Writing your stored procedure
* The Form Screen
* The Report Screen
* Explaining the Form Screen
* Explaining the Report Screen
* Registering your procedure
4. Formatting Result Sets
5. Tips and Techniques
* Frames
* Tables and Forms
* Buttons