文件名称:Beginning Transact-SQL with SQL Server 2000 and 2005 (5 of 5)
文件大小:2.14MB
文件格式:RAR
更新时间:2010-09-28 06:36:31
sql2005 Transact-SQL
Beginning Transact-SQL with SQL Server 2000 and 2005
byPaul TurleyandDan Wood
Wrox Press 2006 (594 pages)
ISBN:076457955X
Prepare for the ever-increasing demands of programming. Beginning with an overview of the SQL Server query operations and tools used with T-SQL, this authoritative text explains how to design and build applications of increasing complexity.
Table of Contents
Beginning Transact-SQL with SQL Server 2000 and 2005
Foreword
Chapter 1 - Introducing Transact-SQL and Data Management Systems
Chapter 2 - SQL Server Fundamentals
Chapter 3 - Tools for Accessing SQL Server
Chapter 4 - Introducing Transact-SQL Language
Chapter 5 - Data Retrieval
Chapter 6 - SQL Functions
Chapter 7 - Aggregation and Grouping
Chapter 8 - Multi-Table Queries
Chapter 9 - Data Transactions
Chapter 10 - Advanced Queries and Scripting
Chapter 11 - Full-Text Index Queries
Chapter 12 - Creating and Managing Database Objects
Chapter 13 - Transact-SQL Programming Objects
Chapter 14 - Transact-SQL in Applications and Reporting
Appendix A - Command Syntax Reference
Appendix B - System Variables and Functions Reference
Appendix C - System Stored Procedure Reference
Appendix D - Information Schema Views Reference
Appendix E - Answers to Exercises