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.
作者簡介
暫缺《SQL Server 2005編程入門》作者簡介
圖書目錄
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
鄂公網(wǎng)安備 42010302001612號 