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

As much as I’d like to be able to produce completely error free books, the reality of the computer publishing industry is that the pace at which books must be written and released makes this very difficult. And regretfully, my own books do have sporadic mistakes and typos scattered throughout them.

For the benefit of my readers, here is a current errata for Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes. Feel free to print this page for future reference.

And as always, if you come across errors that I do not know about, please let me know. I’ll make sure they are added to this list, and will try to have them corrected in future reprints.

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

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