Errata for Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes (Second Edition)

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)

PageLocationCorrection
18Preparing for Your Lessons section, second paragraph, “Appendix B”Preparing for Your Lessons section, second paragraph, “Appendix B”
24NEW TERM block, “Appendix E”Should be: Appendix D
271st OUTPUT block, values in TABLE_QUALIFIER columnShould be: learnsql
37Caution block, text "would be retrieved"Should be: would be excluded
382nd INPUT block, "TOP(25)PERCENT"Should be: TOP(25) PERCENT
70ANALYSIS block, text "any names longer than one character do not match"Should be: "any names longer than one character will match
92ANALYSIS block, first word, "Like"Should be: Unlike
110ANALYSIS block, text "to sort the data and group it by"Should be: to group the data by
137INPUT block5th line of code (starting with AND) should be deleted
169TIP, text: LIKE note_text = '%handsaw%'Should be: WHERE note_text LIKE '%handsaw%'
194Caution block, ‘e’Should be: ”
206OUTPUT block, heading "CUST_NAM"Should be: CUST_NAME
2342nd INPUTShould be: SELECT @Cheap, @Expensive, @Average;
256Paragraph starting "Well, if the", text "before the orders table"Should be: before the orders row
3061st INPUT, text "column columns"Should be: column
306CREATE INDEX section, refers to Lesson 20Should be: Lesson 17