You are currently offline, waiting for your internet to reconnect

Inside Microsoft SQL Server 2008: T-SQL Querying comments and corrections

SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Inside Microsoft SQL Server 2008: T-SQL Querying, 978-0-7356-2603-4.

The following topics are covered:

  • Page xxii: "TSQLFundamentals2008.sql" should be "InsideTSQL2008.sql"
  • Page xxiii: "TSQLFundamentals2008 database" should be "InsideTSQL2008 database.sql"
  • Page 18: Sample output incorrect
  • Page 32: Incorrect sample output
  • Pages 113-117: Shaded columns are missing
  • Page 318: Code incomplete
  • Page 322: Definition of CTE is incomplete
  • Page 331: Incorrect code sample
  • Pages 389-390: Incorrect code samples
  • Page 490: Query incorrect
MORE INFORMATION

Page xxii: "TSQLFundamentals2008.sql" should be "InsideTSQL2008.sql"

On page xxii: the first sentence of the last paragraph references the wrong sql script file.

Change:
"After downloading the source code, run the script file TSQLFundamentals2008.sql to create the sample database InsideTSQL2008, which is used in many of the books’ code samples."

To:
"After downloading the source code, run the script file InsideTSQL2008.sql to create the sample database InsideTSQL2008, which is used in many of the books’ code samples."

Page xxiii: "TSQLFundamentals2008 database" should be "InsideTSQL2008 database.sql"

On page xxiii, the caption for Figure I-1 contains an incorrect database reference.

Change:
"FIGURE I-1 Data model of the TSQLFundamentals2008 database"

To:
"FIGURE I-1 Data model of the InsideTSQL2008 database.sql"

Page 18: Sample output incorrect

On page 18, the output at the bottom of the page is incorrect.

Change:
orderid customerid-----------	----------11077	RATTC11076	BONAP11075	RICSU
To:
orderid customerid-----------	----------7		NULL6 	MRPHS5 	KRLOS

Page 32: Incorrect sample output

On page 32, the query output is incorrect.

Change:
country       region         city---------------    ---------------    ---------------USA            WA             KirklandUSA            WA             Seattle

To:
region         city---------------    ---------------WA             KirklandWA             Seattle


Pages 113-117: Shaded columns are missing

On pages 113-117, Tables 3-1 through 3-17, a reference is made to the column that is part of the key is shaded. Unfortunately, all of the columns are shaded in each table.

The columns that should be shaded are:
Table 3-1
OderId

Table 3-2
OrderId
ItemId

Table 3-3
OrderId

Table 3-4
OrderId
ItemId

Table 3-5
CustomerId

Table 3-6
OrderId

Table 3-7
OrderId
ItemId

Table 3-8
ProductId

Table 3-9
CustomerId
OrderDate
DueDate

Table 3-10
CustomerId
OrderDate

Table 3-11
OrderId

Table 3-12
Employee
Project
Activity

Table 3-13
Employee
Project
Activity

Table 3-14
Employee
Project

Table 3-15
Employee
Activity

Table 3-16
Employee
Project
Activity

Table 3-17
Project
Activity

Page 318: Code incomplete

On page 318, the code example for derived tables is incomplete.

Change:
FROM (derived_table_query) AS derived_table_alias

To:
Should be: FROM (<derived_table_query>) AS <derived_table_alias>


Page 322: Definition of CTE is incomplete

On page 322, the definition for CTE after the first paragraph is incomplete.

Change:
WITH cte_nameAS(cte_query)outer_query_referring_to_cte_name

To:
WITH	<cte_name> [( <target_column_list> )]  AS  (    <inner_query_defining_cte>  		)   <outer_query_against_cte>;

Page 331: Incorrect code sample

On page 331, the second code sample is incorrect.

Change:
ranking_function OVER([PARTITION BY col_list] ORDER BY col_list)

To:
OVER([PARTITION BY ] ORDER BY )


Pages 389-390: Incorrect code samples

On pages 389 and 390, the second lines of the code samples are incorrect.

Change:
WHERE where_predicate

To:
WHERE


Page 490: Query incorrect

On page 490, the query near the top of the page is incorrect.

Change:
SELECT groupid,CAST(ROUND(EXP(SUM(LOG(ABS(NULLIF(val,0)))))*(1-SUM(1-SIGN(val))%4)*(1-SUM(1-SQUARE(SIGN(val)))),0) AS INT)AS productFROM dbo.GroupsGROUP BY groupid;

To:
SELECT groupid,CAST(ROUND(EXP(SUM(LOG(ABS(NULLIF(val,0)))))*(1-SUM(1-SIGN(val))%4)*(1-MAX(1-SQUARE(SIGN(val)))),0) AS INT)AS productFROM dbo.GroupsGROUP BY groupid;

Microsoft Press is committed to providing informative and accuratebooks. All comments and corrections listed above are ready forinclusion in future printings of this book. If you have a later printingof this book, it may already contain most or all of the above corrections.
978-0-7356-2603-4 0-7356-2603-0
Properties

Article ID: 972927 - Last Review: 06/24/2009 16:51:42 - Revision: 1.4

Inside Microsoft SQL Server 2008: T-SQL Querying, ISBN 978-0-7356-2603-4

  • KB972927
Feedback