If you’re a database programmer working with SQL Server 2000 or SQL Server 2005, you need to know Transact-SQL. This book’s a great way to learn it from scratch.
Longtime Microsoft database consultant and instructor Paul Turley covers every facet of writing Transact-SQL code, from syntax to tools -- including SQL Server 2005’s new query-building and editing tools. You’ll start with the basics: data retrieval, SQL functions, aggregation, and grouping. But you’ll quickly move on to more sophisticated techniques: multi-table and advanced queries, transactions, full-text index queries, and more. You’ll learn how to create T-SQL programming objects; then walk through putting T-SQL to work in realistic applications and reporting scenarios. Everything’s illuminated with code examples -- all utilizing the Adventure Works Cycles sample database that comes with SQL Server. Bill Camarda, from the October 2005 Read Only