Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes
- ISBN: 0672328674
- Pages: 320
- Publisher: Sams - August 1, 2007
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.
Location: Paragraph before final Input block, words: with the letter J or the letter M
Error: Should be: with the letter E or the letter J
Location: Third bullet, words: The state stored
Error: Should be: The country stored
Location: TIP, 5th line, words: SELECT TRIM(' ABC ')
Error: Should be: SELECT LTRIM(RTRIM(' ABC '))
Location: Table 10.3, weekday, text in parentheses
Error: Should be: (DateName() and DatePart() only)
Location: Second INPUT block, second line of code
Error: Should be: DateName(weekday, order_date) AS weekday
Location: Analysis block, second line, both code examples
Error: Second parameter to DateName() should be an actual date
Location: Line before bulleted list: of dates
Error: Should be: of dates, including
Location: Line after TIP box: So how do you filter rows?
Error: Should be: So how do you filter groups?
Location: Final INPUT block contains the wrong SQL statement
Error: 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
Location: First INPUT block
Error: Should be: SELECT @cheap AS Cheap
Location: Second INPUT block
Error: Should be: SELECT @cheap AS Cheap, @expensive AS Expensive, @average AS Average
Location: Final line of INPUT block: GrantTotal
Error: Should be: GrandTotal
Location: Analysis block, line beginning "grant total": grant
Error: Should be: grand
Location: Table D2, description for BIGINT
Error: Second number should not have - in front of it