library_image

Errata: Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes

Home » Errata: Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes

Errata: Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes


Original printing (320 pages, published August 1, 2007)

PageLocationCorrection
65Paragraph before final Input block, words: with the letter J or the letter MShould be: with the letter E or the letter J
72Third bullet, words: The state storedShould be: The country stored
76TIP, 5th line, words: SELECT TRIM(‘ ABC ‘)Should be: SELECT LTRIM(RTRIM(‘ ABC ‘))
83Table 10.3, weekday, text in parenthesesShould be: (DateName() and DatePart() only)
84Second INPUT block, second line of codeShould be: DateName(weekday, order_date) AS weekday
85Line before bulleted list: of datesShould be: of dates, including
85Analysis block, second line, both code examplesSecond parameter to DateName() should be an actual date
104Line after TIP box: So how do you filter rows?Should be: So how do you filter groups?
131Final INPUT block contains the wrong SQL statementShould be: SELECT customers.cust_id, customers.cust_name FROM customers INNER JOIN orders ON customers.cust_id = orders.cust_id WHERE DateDiff(month, order_date, ‘2005-09-01’) = 0
230First INPUT blockShould be: SELECT @cheap AS Cheap
230Second INPUT blockShould be: SELECT @cheap AS Cheap, @expensive AS Expensive, @average AS Average
242Final line of INPUT block: GrantTotalShould be: GrandTotal
242Analysis block, line beginning “grant total”: grantShould be: grand
312Table D2, description for BIGINTSecond number should not have – in front of it