MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 comments and corrections

This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005, 978-0-7356-2383-5.

The following topics are covered:

• Page 14: SqlConnection missing from code sample
• Page 29: SQL.GetProducts should be SQL.GetEngineeringList
• Page 85: Code sample missing closing brace
• Pages 110 & 111: "production.product" should be "Production.Product"

Page 14: SqlConnection missing from code sample

On page 14, on the second to last line of the code sample the SqlConnection variable type is missing.

Change:
To:

Page 29: SQL.GetProducts should be SQL.GetEngineeringList

On page 29, the fifth line of the C# code sample for step 11 contains an incorrect variable definition.

Change:


To:

Page 85: Code sample missing closing brace

On page 85, line 16 in the second set of code sample on the page is missing a closing brace.

Change:
To:

Pages 110 & 111: "production.product" should be "Production.Product"

On page 110 & 111, in both the VB and C# code example the query string is incorrect.

In the C# example change:
To:
In the VB example change:
To:
Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.