文档介绍：spine="
Wrox Programmer to ProgrammerTM Wrox Programmer to ProgrammerTM
Beginning Turley, Wood
T-SQL
®
with Microsoft SQL Server ® 2005 and 2008
Nearly all business applications read, store, and manipulate data stored in
relational databases. If you use Microsoft SQL Server in any way, you need to Beginning
learn and use T-SQL, Microsoft’s powerful implementation of the ANSI-standard Microsoft with T-SQL
SQL database query language.
This book teaches all of the basics of T-SQL as it’s used with SQL Server 2005
and 2008 databases. The authors, leading T-SQL experts, begin with the
essentials of SQL Server that are needed to get the most from T-SQL. They then
quickly move on to introduce T-SQL itself, including the core elements of data
retrieval, SQL functions, aggregation and grouping, and multi-table queries, and
they fully explain transaction processing and data manipulation using T-SQL.
The authors also show you how to create and manage T-SQL programming
objects, including views, functions, and stored procedures. They detail how to
optimize T-SQL query performance and design queries for real-world business
applications. All of the methods and techniques in this book can be used with
®
both Microsoft SQL Server 2005 and 2008 databases. Server SQL
In addition, the book includes prehensive set of reference appendices,
including T-mand syntax, system variables and functions, system stored
procedures, information schema views, and FileStream objects.
What you will learn from this book Beginning
● How to add, modify, and remove records
● How to query multiple tables
● Ways to use views to modify data
Enhance Your Knowledge
● How to create tools for managing databases using T-SQL
Advance Your Career ®
● T-SQL programming techniques using views, user-defined functions, and stored 2008 and 2005
procedures
● Methods for optimizing query performance
● How to use SQL Server Reporting Servic