Errata

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

Errata for MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Printed
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();

 Microsoft Press  Jul 13, 2010 
Printed
Page 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.

 Microsoft Press  Jul 13, 2010 
Printed
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);

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

 Microsoft Press  May 06, 2010