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 (Second Edition). 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 (368 pages, published December 12, 2016)
| Page | Location | Correction |
|---|---|---|
| 18 | Preparing for Your Lessons section, second paragraph, “Appendix B” | Preparing for Your Lessons section, second paragraph, “Appendix B” |
| 24 | NEW TERM block, “Appendix E” | Should be: Appendix D |
| 27 | 1st OUTPUT block, values in TABLE_QUALIFIER column | Should be: learnsql |
| 37 | Caution block, text “would be retrieved” | Should be: would be excluded |
| 38 | 2nd INPUT block, “TOP(25)PERCENT” | Should be: TOP(25) PERCENT |
| 70 | ANALYSIS block, text “any names longer than one character do not match” | Should be: “any names longer than one character will match |
| 92 | ANALYSIS block, first word, “Like” | Should be: Unlike |
| 110 | ANALYSIS block, text “to sort the data and group it by” | Should be: to group the data by |
| 137 | INPUT block | 5th line of code (starting with AND) should be deleted |
| 169 | TIP, text: LIKE note_text = ‘%handsaw%’ | Should be: WHERE note_text LIKE ‘%handsaw%’ |
| 194 | Caution block, ‘e’ | Should be: ” |
| 234 | 2nd INPUT | Should be: SELECT @Cheap, @Expensive, @Average; |
| 256 | Paragraph starting “Well, if the”, text “before the orders table” | Should be: before the orders row |
| 306 | 1st INPUT, text “column columns” | Should be: column |
| 306 | CREATE INDEX section, refers to Lesson 20 | Should be: Lesson 17 |