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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

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

Version Location Description Submitted by Date Submitted
Printed, PDF Page 16
Step 4 of Exercise 2

The name property of the button control does not match that given in either the C# code or the VB code that follows.

Name = btnOpenSNAC

should be

Name = btnOpenSNC

 Michael Hitchin  Sep 14, 2010 
Printed, PDF Page 303
Step 4 of Exercise 3

LEFT OUTER JOIN Test.SalesOrderHeader AS soh
ON soh.CustomerID = c.CustomerID
WHERE c.TerritoryID = 2

should be:

LEFT OUTER JOIN Test.SalesOrderHeader AS soh
ON soh.CustomerID = c.CustomerID
WHERE c.TerritoryID = 1

 Michael Hitchin  Sep 10, 2010 
Printed, PDF Page 292
First paragraph

The description of the noncorrelated subquery does not match the T-SQL that follows it.

Either

"The following example uses a subquery to return all products that are cheaper than the average product price."

should be

"The following example uses a subquery to return all products that are more expensive than the average product price."

or

WHERE p.ListPrice >

should be

WHERE p.ListPrice <

 Michael Hitchin  Sep 09, 2010 
Printed, PDF Page 203
Last line

Return CType(cmd.ExecuteScalar(), Boolean

should be

Return CType(cmd.ExecuteScalar(), Boolean)

 Michael Hitchin  Sep 08, 2010 
Printed, PDF Page 203
VB Code

DataAccess:=DataAccessKind.None

should be

DataAccess:=DataAccessKind.Read

 Michael Hitchin  Sep 08, 2010 
Printed, PDF Page 186
Following Step 7 in Exercise 1

The step that would add a button control to the design is missing; probably something to do with the naming of the button, which is different in the VB code that follows the C# code.

 Michael Hitchin  Sep 02, 2010 
Printed, PDF, Other Digital Version Page 188
VB code listing

"MultipleActiveResultSets=True" should be "Asynchronous Processing=True"

This error also exists in the lab file on the companion CD, which can only mean that it was published without testing!

 Michael Hitchin  Sep 02, 2010 
Printed, PDF Page 78
Last sentence

The last sentence says "...replace all instances of single quotes (') with four quotes ('' '').

What it ought to say is that all single quotes within the XML must be replaced with a pair of single quotes. The paragraph needs completely rewriting to make it clear that it is only the XML that needs to have the single quotes replaced, not the the entire procedure.

 Michael Hitchin  Aug 29, 2010