- This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself
- Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server
- Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more
- Features updated and new material, including new examples using Microsoft's AdventureWorks sample database
Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?
Chapter 2: Tools of the Trade.
Chapter 3: The Foundation Statements of T-.
Chapter 4: JOINs.
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: System Functions.
Appendix B: Very Simple Connectivity Examples.
|12||Error in Text|
As of SQL Server 2008, full-text catalogs have been intergrated into the mail database engine...
As of SQL Server 2008, full-text catalogs have been intergrated into the main database engine...
|16||Error in Text|
In the box on page 16:
"SQL Server has no concept of unsigned numeric data types."
"SQL Server has no concept of unsigned numeric data types, except for TinyInt."
|406||Error in Text|
"The first executable line of our sproc is a bit deceptive - it is the DELCARE statement for @WorkingIn."
"The first executable line of our sproc is a bit deceptive - it is the DECLARE statement for @WorkingIn."
|581||Error in Text|
The sentence "You can feed it a list and say 'do all of these please!'" should read "You can't feed it a list and say 'do all of these please!" The 't is missing.