Errata

Programming Microsoft SQL Server 2012

Errata for Programming Microsoft SQL Server 2012

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 Page xxxiii
Code Samples Section

The companion code only contains the AdventureWorks sample databases, not the chapter by chapter code as indicated in the introduction (p. xxxiii)

 Shelby  Aug 23, 2012 
Printed Page Page xxxiii Code Samples Section
United States

The companion download (9780735658226_files.zip) now contains all the sample code. Issue resolved, thanks!

 Shelby  Sep 27, 2012 
PDF Page 274
India

The Query for Listing 6-18 doesn't include Column SalesOrderDetailID in SELECT Column List due to which the formatted XML Result as output is not correct for SalesOrderID = 44407. Here is change that is required in query:

SELECT
1 AS Tag,
NULL AS Parent,
CustomerID AS [Customer!1!CustomerID],
NULL AS [SalesOrder!2!SalesOrderID],
NULL AS [SalesOrder!2!TotalDue],
NULL AS [SalesOrder!2!OrderDate!ELEMENT],
NULL AS [SalesOrder!2!ShipDate!ELEMENT],
NULL AS [SalesDetail!3!SalesOrderDetailID], -- Change required
NULL AS [SalesDetail!3!ProductID],
NULL AS [SalesDetail!3!OrderQty],
NULL AS [SalesDetail!3!LineTotal]
FROM Sales.Customer AS Customer
WHERE Customer.CustomerID IN(11077, 11078)
UNION ALL
SELECT
2,
1,
Customer.CustomerID,
OrderHeader.SalesOrderID,
OrderHeader.TotalDue,
OrderHeader.OrderDate,
OrderHeader.ShipDate,
NULL,
NULL,
NULL,
NULL
FROM Sales.Customer AS Customer
INNER JOIN Sales.SalesOrderHeader AS OrderHeader
ON OrderHeader.CustomerID = Customer.CustomerID
WHERE Customer.CustomerID IN(11077, 11078)
UNION ALL
SELECT
3,
2,
Customer.CustomerID,
OrderHeader.SalesOrderID,
OrderHeader.TotalDue,
OrderHeader.OrderDate,
OrderHeader.ShipDate,
OrderDetail.SalesOrderDetailID,
OrderDetail.ProductID,
OrderDetail.OrderQty,
OrderDetail.LineTotal
FROM Sales.Customer AS Customer
INNER JOIN Sales.SalesOrderHeader AS OrderHeader
ON OrderHeader.CustomerID = Customer.CustomerID
INNER JOIN Sales.SalesOrderDetail AS OrderDetail
ON OrderDetail.SalesOrderID = OrderHeader.SalesOrderID
WHERE Customer.CustomerID IN(11077, 11078)
ORDER BY [Customer!1!CustomerID], [SalesOrder!2!SalesOrderID]--,[SalesDetail!3!SalesOrderDetailID]
FOR XML EXPLICIT

 Kunal Abrol  Oct 17, 2013 
Printed Page 504
Listing 10-18

Cannot get Visual Studio 2012 to resolve reference to CreateQuery().

What references should I use?

I have added

using System.Data.Entity;
using System.Data.EntityClient;
using System.Data.EntityModel;
using System.Data.Objects;

to no avail.

A search of the Internet has also proved fruitless

 Barry Huett  Feb 16, 2013 
Printed Page 544
Penultimate line

The phrase: "... attribute exposes the public method GetCustomersByLastName..."

should read: "... attribute exposes the public method GetCustomersByBalance"

 Barry Huett  Feb 19, 2013