Transact-SQL Programming

Publisher: O’Reilly Media
Language: English
ISBN: 1565924010
Paperback: 836 pages
Data: Apr 1999
Format: PDF






Description: This definitive guide thoroughly explores all aspects of Transact-SQL, a full-featured procedural language used on both Microsoft SQL Server and Sybase SQL Server systems that dramatically extends the power of SQL (Structured Query Language). Full of examples, best practices, and real-world advice, it contains up-to-the-minute information on the latest versions: Microsoft SQL Server versions 6.5 and 7.0 and Sybase version 11.5. The book is divided into six convenient parts. Part I contains an introduction, an SQL primer, and chapters on language fundamentals, format, and style. Part II describes datatypes and variables, conditional processing, cursors, error handling, temporary objects, transactions, and locking. Part III covers the various types of functions available to programmers and CASE extensions to the language. Part IV discusses stored procedures and modular design, triggers, views, extended stored procedures, and BCP. Part V describes code design and maintenance, optimization, tuning, transactions, locking, testing, and debugging. The appendixes summarize system tables and version differences. The enclosed CD-ROM contains an extensive set of examples from the book and complete programs that illustrate the power of the language.

Google Book
Amazon

Download:
http://rapidshare.com/files/178230899/1565924010.zip