SQL Server 2005编程入门 Beginning SQL Server 2005 Programming
点此进入淘宝搜索页搜索分類: 图书,计算机/网络,数据库,SQL,
作者： Robert Vieira 著
出 版 社： John Wiley & Sons
出版时间： 2007-7-1字数：版次： 1页数： 688印刷时间： 2007/07/01开本：印次：纸张： 胶版纸I S B N ： 9780764584336包装： 平装内容简介
This comprehensive introduction to SQL Server 2005 programming serves as a useful guide for the novice as well the advanced SQL Server user.With the extensive redesign of SQL Server for the 2005 release, it proves itself to be a solid review and reference book intended to be useful well beyond your days as a beginning programmer.
Covering all the fundamentals of SQL Server 2005, this developer-oriented guide begins with an exploration of the foundation objects of SQL. Each chapter builds on the previous one, gradually progressing to increasingly advanced topics. By the time you've completed this book, you will be prepared to perform as an efficient SQL Server 2005 programmer, and, when ready, move on to the more advanced Professional title.
作者简介：
Robert Vieira is one of the leading authorities on Microsoft SQL Server and author of the bestselling title from Wrox Press, Professional SQL Server 2000 Programming, with nearly 40,000 copies in print. Vieira is currently a Software Architect for NetIQ Corporation in Portland, OR, where he performs design work and coaches other developers. He speaks frequently at both public and private conferences nationally, and is perhaps best known for his light-hearted approach to teaching and writing.
目录
Acknowledgments
Introduction
Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?
An Overview of Database Objects
The Database Object
The Transaction Log
The Most Basic Database Object: Table
Filegroups
Diagrams
Views
Stored Procedures
User-Defined Functions
Users and Roles
Rules
Defaults
User-Defined Data Types
Full-Text Catalogs
SQL Server Data Types
NULL Data
SQL Server Identifiers for Objects
What Gets Named?
Rules for Naming
Summary
Chapter 2: Tools of the Trade
Books Online
The SQL Server Configuration Manager
Service Management
Network Configuration
The Protocols
On to the Client
The SQL Server Management Studio
Getting Started
Query Window
SQL Server Integration Services (SSIS)
Bulk Copy Program (bcp)
SQL Server Profiler
sqlcmd
Summary
Chapter 3: The Foundation Statements of T-SQL
Getting Started with a Basic SELECT Statement
The SELECT Statement and FROM Clause
The WHERE Clause
ORDER BY
Aggregating Data Using the GROUP BY Clause
Placing Conditions on Groups with the HAVING Clause
Outputting XML Using the FOR XML Clause
Making Use of Hints Using the OPTION Clause
The DISTINCT and ALL Predicates
Adding Data with the INSERT Statement
The INSERT INTO... SELECT Statement
Changing What You've Got with the UPDATE Statement
The DELETE Statement
Summary
Exercises
Chapter 4: JOINs
JOINs
INNER JOINs
How an INNER JOIN Is Like a WHERE Clause
OUTER JOINs
The Simple OUTER JOIN
Dealing with More Complex OUTER JOINs
Seeing Both Sides with FULL JOINs
CROSS JOINs
Exploring Alternative Syntax for Joins
An Alternative INNER JOIN
An Alternative OUTER JOIN
An Alternative CROSS JOIN
……
Chapter 5: Creating and Altering Tables
Chapter 6: Constraints
Chapter 7: Adding More to Our Queries
Chapter 8: Being Normal: Normalization and Other Basic Design Issues
Chapter 9: SQL Server Storage and Index Structures
Chapter 10: Views
Chapter 11: Writing Scripts and Batches
Chapter 12: Stored Procedures
Chapter 13: User Defined Functions
Chapter 14: Transactions and Locks
Chapter 15: Triggers
Chapter 16: A Brief XML Primer
Chapter 17: Reporting for Duty, Sir!: A Look At Reporting Services
Chapter 18: Getting Integrated With Integration Services
Chapter 19: Playing Administrator
Appendix A: Exercise Solutions
Appendix B: System Functions
Appendix C: Finding the Right Tool
Appendix D: Very Simple Connectivity Examples
Appendix E: Installing and Using the Samples
Index
