Errata

  • Article

Book Errata

Here are corrections logged for SQL Server 2008 Transact-SQL Recipes.

Two of my requested changes that I submitted to the publisher didn’t get integrated into to Chapter 2. There were some syntax changes that were made in the Release Candidate that differ from CTP 6. The two changes that didn’t get in are as follows:

Chapter 2, Page 91 - the CTP6 version of the MERGE syntax, instead of the RC0 version was used. Here is the corrected, RC0 version of the syntax:

MERGE INTO HumanResources.CorporateHousing p
USING dbo.StagingCorporateHousing s
ON p.UnitNBR = s.UnitNBR
WHEN MATCHED AND s.IsRentedIND <> p.IsRentedIND THEN
UPDATE SET IsRentedIND = s.IsRentedIND
WHEN NOT MATCHED BY TARGET THEN
INSERT (UnitNBR, IsRentedIND) VALUES (s.UnitNBR, s.IsRentedIND)
WHEN NOT MATCHED BY SOURCE THEN
DELETE;

Chapter 2, Page 98 - the @partition_switch argument should be removed from sys.sp_cdc_enable_table

Other corrections are as follows:

  • Chapter 28, Page 782.  The sentence “You can create resource pools using the CREATE WORKLOAD GROUP command” should read “You can create workload groups using the CREATE WORKLOAD GROUP command.”