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

Article translations Article translations
Article ID: 937632 - View products that this article applies to.
Expand all | Collapse all

On This Page

SUMMARY

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"

MORE INFORMATION

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:
sqlConn = new SqlConnection(connString);

To:
SqlConnection sqlConn = new SqlConnection(connString);


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:
SQL.GetProducts ws = new SQL.GetEngineeringList();


To:
SQL.GetEngineeringList ws = new SQL.GetEngineeringList();


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:
WHERE pm.Instructions.value('(AW:root/AW:Location/@LocationID[1]', 'int')= @LocID

To:
WHERE pm.Instructions.value('(AW:root/AW:Location/@LocationID)[1]', 'int')= @LocID

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:
String queryString = "select * from production.product";

To:
String queryString = "select * from Production.Product";

In the VB example change:
Dim queryString As String = "select * from production.product"

To:
Dim queryString As String = "select * from Production.Product"

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.

Properties

Article ID: 937632 - Last Review: May 23, 2007 - Revision: 1.3
APPLIES TO
  • MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005, ISBN 0-7356-2383-X
Keywords: 
KB937632

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com