In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Mor

Demonstrates the SQL Server 2000 programming fundamentals, including database structures and TransactSQL.

Provides detailed information about Transact-SQL programming and shows specific differences between the Microsoft and Sybase versions of the language.

Encoded characteristic functions (ECF) is a new, innovative SQL programming methodology which allows programmers to encode conditional logic as scalar expressio

This book is written for SQL Server 2008. However, it does maintain roots going back a few versions and looks out for backward compatibility issues with SQL Ser