Part 1: Introducing SQL Server.
Chapter 1: Introduction to SQL Server 2005.
Chapter 2: Overview of Database Concepts.
Chapter 3: Overview of SQL Server.
Chapter 4: Database Design and Normalization.
Part 2: Transact-SQL.
Chapter 5: Transact-SQL Overview and Basics.
Chapter 6: SELECT Queries.
Chapter 7: Action Queries.
Chapter 8: Topics in Advanced Transact-SQL.
Part 3: Digging into SQL Server.
Chapter 9: Using SQL Server Management Studio.
Chapter 10: Databases.
Chapter 11: Tables.
Chapter 12: Indexing.
Chapter 13: Views.
Chapter 14: Stored Procedures.
Chapter 15: Using Triggers.
.Part 4: Administering SQL Server.
Chapter 16: Basic Administrative Tasks.
Chapter 17: Automating Administration.
Chapter 18: Security and SQL Server 2005.
Part 5: Development with SQL Server.
Chapter 19: Integrating SQL Server with Microsoft .NET.
Chapter 20: ADO.NET and SQL Server.
Chapter 21: SMO and RMO Programming.
Chapter 22: Integration Services.
Part 6: Advanced Topics.
Chapter 23: Locking.
Chapter 24: Monitoring and Optimizing SQL Server 2005.
Chapter 25: Replication.
Chapter 26: Analysis Services.
Chapter 27: Notification Services.
Chapter 28: Reporting Services.
Chapter 29: Service Broker.
Chapter 30: Troubleshooting.
Appendix A: Transact-SQL Reference.
|6||148||Mislabeled Table on Pg. 148|
Chapter 6, page 148, has a mislabeled table: "HumanResources.Employee.DepartmentID" should be changed to "HumanResources.Employee.Employee ID"
It appears that the method described was modified in the Production Edition and the Stored Procedure Assisted Editor is not part of the final released edition. The actual procedure should be as described: