library_image

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

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


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: ”
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