The most comprehensive book available on th Sybase SQL Server today, this book enables readers to gain a knowledge of the programming and database administration aspects behind this popular RDBMS (relational database management system). The CD-ROM includes the Aurora Desktop, a compact SQL editor with some of the features of the full-size Aurora Script Manager.

Transact-SQL is a procedural language used on both Microsoft SQL Server and Sybase SQL Server systems. It is a full-featured programming language that dramatically extends the power of SQL (Structured Query Language).The language provides programmers with a broad range of features, including: A rich set of datatypes, including specialized types for identifiers, timestamps, images, and long text fieldsLocal and global variablesFully programmable server objects like views, triggers, stored procedures, and batch command filesConditional processingException and error handlingFull transaction controlSystem stored procedures that reduce the complexity of many operations, like adding users or automatically generating HTML Web pagesIn recent years, the versions of Transact-SQL have diverged on Microsoft and Sybase systems; the book explains the differences. It also contains up-to-the-minute information on the latest versions: Microsoft SQL Server versions 6.5 and 7.0 and Sybase version 11.5.A brief table of contents follows: PART I: The Basics: Programming in Transact-SQL1. Introduction to Transact-SQL2. Matching Business Rules3. SQL Primer4. Transact-SQL Fundamentals5. Format and StylePART II: The Building Blocks: Transact-SQL Language Elements6. Datatypes and Variables7. Conditional Processing8. Row Processing with Cursors9. Error Handling10. Temporary Objects11. Transactions and LoggingPART III: Functions and Extensions12. Functions13. CASE Expressions and Transact-SQL ExtensionsPART IV: Programming Transact-SQL Objects14. Stored Procedures and Modular Design15. Triggers16. Views17. System and Extended Stored Procedures and BCPPART V: Performance Tuning and Optimization18. Transact-SQL Code Design19. Code Maintenance in the SQL Server20. Transact-SQL Optimization and Tuning21. Debugging Transact-SQL ProgramsPART VI: AppendixesA. System TablesB. What's New for Transact-SQL in Microsoft SQL Server 7.0? C. BCPThe book comes with a CD-ROM containing an extensive set of examples from the book and complete programs that illustrate the power of the language.

This text offers a detailed look at Sybase SQL Server Performance Tuning and a sneak peek at Sybase System 11 performance features. It compares and contrasts all recent major releases of Sybase SQL Server

For sybase database administrators and IS managers, and for students of computer science and databases. This is the first book that shows Sybase database administrators exactly how to manage complex multi-SQL Server environments.

The Sybase IQ Survival Guide is a clear and concise roadmap through the wealth of information out there, presented in logical steps and enhanced with the authors considerable hands on experience. All you need to get going with this book is a basic knowledge of SQL and databases. This guide has hundreds of tested methods for executing day to day tasks as well as hints, tips and guidance derived from the authors 10 years experience with the product. The following chapters are included: - - Introduction to IQ - Creating, Running and Stopping a Database/Server - Security - SQL - Loading, Extracting and Moving Data - Tables, Data Types and Views - Indexes - Stored Procedures, Functions and Triggers - Transaction Management - Backups, Restores & DR - Multiplex - Java in the IQ - Remote Objects & Application/Language Connectivity - Tips and Tricks - System Tables and Views - System Procedures - Options - Migration from Other Databases