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

Article translations Article translations
Article ID: 972927 - View products that this article applies to.
Expand all | Collapse all

On This Page

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	RATTC
11076	BONAP
11075	RICSU
To:
orderid customerid
-----------	----------
7		NULL
6 	MRPHS
5 	KRLOS

Page 32: Incorrect sample output

On page 32, the query output is incorrect.

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

To:
region         city
---------------    ---------------
WA             Kirkland
WA             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_name
AS
(
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 product
FROM dbo.Groups
GROUP 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 product
FROM dbo.Groups
GROUP BY groupid;

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.

Properties

Article ID: 972927 - Last Review: June 24, 2009 - Revision: 1.4
APPLIES TO
  • Inside Microsoft SQL Server 2008: T-SQL Querying, ISBN 978-0-7356-2603-4
Keywords: 
KB972927

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com