Books

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.

Page 65

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

Page 72

Location: Third bullet, words: The state stored
Error: Should be: The country stored

Page 76

Location: TIP, 5th line, words: SELECT TRIM(' ABC ')
Error: Should be: SELECT LTRIM(RTRIM(' ABC '))

Page 83

Location: Table 10.3, weekday, text in parentheses
Error: Should be: (DateName() and DatePart() only)

Page 84

Location: Second INPUT block, second line of code
Error: Should be: DateName(weekday, order_date) AS weekday

Page 85

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

Page 104

Location: Line after TIP box: So how do you filter rows?
Error: Should be: So how do you filter groups?

Page 131

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

Page 230

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

Page 242

Location: Final line of INPUT block: GrantTotal
Error: Should be: GrandTotal
Location: Analysis block, line beginning "grant total": grant
Error: Should be: grand

Page 312

Location: Table D2, description for BIGINT
Error: Second number should not have - in front of it

Back to Book Information