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)
| Page | Location | Correction |
|---|---|---|
| 65 | Paragraph before final Input block, words: with the letter J or the letter M | Should be: with the letter E or the letter J |
| 72 | Third bullet, words: The state stored | Should be: The country stored |
| 76 | TIP, 5th line, words: SELECT TRIM(‘ ABC ‘) | Should be: SELECT LTRIM(RTRIM(‘ ABC ‘)) |
| 83 | Table 10.3, weekday, text in parentheses | Should be: (DateName() and DatePart() only) |
| 84 | Second INPUT block, second line of code | Should be: DateName(weekday, order_date) AS weekday |
| 85 | Line before bulleted list: of dates | Should be: of dates, including |
| 85 | Analysis block, second line, both code examples | Second parameter to DateName() should be an actual date |
| 104 | Line after TIP box: So how do you filter rows? | Should be: So how do you filter groups? |
| 131 | Final INPUT block contains the wrong SQL statement | Should 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 |
| 230 | First INPUT block | Should be: SELECT @cheap AS Cheap |
| 230 | Second INPUT block | Should be: SELECT @cheap AS Cheap, @expensive AS Expensive, @average AS Average |
| 242 | Final line of INPUT block: GrantTotal | Should be: GrandTotal |
| 242 | Analysis block, line beginning “grant total”: grant | Should be: grand |
| 312 | Table D2, description for BIGINT | Second number should not have – in front of it |