作者:Itzik Ben-gan
出版日期:October 22, 2008
出版社:Microsoft Press
页数:688
ISBN:ISBN-10: 0735626014 ISBN-13: 978-0735626010
文件格式:CHM
Product Description
This book walks you through your first steps in T-SQL (also known asTransact-SQL), which is Microsoft SQL Server s dialect of the standardANSI-SQL language. You ll learn the theory behind T-SQL querying andprogramming, how to develop T-SQL code to query and modify data, andget an overview of programmable objects. Although this book is intendedfor beginners, it is not merely a step-by-step book. It goes beyond thesyntactical elements of T-SQL and explains the logic behind thelanguage and its elements. Many aspects of SQL are unique to thelanguage, and are very different from other programming languages. Thisbook helps you adopt the right state of mind and gain a trueunderstanding of the language elements. You learn how to think in termsof sets and follow good SQL programming practices. The book is notversion-specific; it does, however, cover language elements that wereintroduced in recent versions of SQL Server, including SQL Server 2008.To complement the learning experience, the book provides exercises thatenable you to practice what you ve learned. The book starts with atheoretical background to T-SQL querying and programming (Chapter 1)laying the foundations for the rest of the book, and also coverage ofcreating tables and defining data integrity. The book moves on tovarious aspects of querying and modifying data (Chapters 2 through 8),then to a discussion of concurrency and transactions (Chapter 9), andfinally provides an overview of programmable objects (Chapter 10). Thisbook features a companion Web site that makes available to you all thecode used in the book, the errata, additional resources, and more.