About Kevin Kline, Lee Gould & Andrew Zanevsky

Transact-SQL Programming - Full of examples, best practices, and real-world advice, this book thoroughly explores Transact-SQL, a full-featured procedural language that extends the power of SQL on both Microsoft SQL Server 6.5/7.0 and Sybase version 11.5. Comes with a CD-ROM containing extensive examples. cover
Transact-SQL Programming – Sample Chapter 1

Transact-SQL, an extension to the SQL database programming language, is a powerful language offering many features–a wide variety of datatypes, temporary objects, system and extended stored procedures, scrollable cursors, conditional processing, transaction control, exception and error handling, and much more. We’ll introduce those features later in this chapter in the section “What is Transact-SQL?” Before getting to Transact-SQL specifics, however, we’ll provide some background information that will help you get a feel for the overall database environment in which Transact-SQL operates. After we explain the basic differences between ANSI SQL and Transact-SQL, we’ll jump back to more generalized topics. We’ll cover the genesis of the relational database model and its impact on SQL programming languages. We’ll talk a bit about normalizing data and introduce you to the idea of row-processing and set-processing information technology. We’ll spend a little time talking about the history of SQL Server in general. Finally, we’ll introduce many of the features of the Transact-SQL programming language itself.