Eratta

Title:   SQL Demystified
ISBN:    0-07-226224-9
Author:  Andy Oppel
Edition: 1st (2005)

Page 32:  "c. User Views" should read "c. Views".  There is a subtle distinction between the two -- User Views are conceptual modeling objects that do not physically exist in the database, while Views are formally defined in the database. The term "User Views" makes this a bit of a trick question, so changing it to "Views" is more reasonable for a self-teaching guide.

Page 41:  In SQL Server 2005, the functions of Query Analyzer have been merged into the SQL Server Management Studio

Page 64:  "Numeric data with a precision from 1 through 38 and a precision from -84 through 127." should read "Numeric data with a precision from 1 through 38 and a scale from -84 through 127."

Page 71:  There is a misplaced closing square bracket in the basic syntax for the CREATE TABLE statement.  "[,<table_constraint] ...);" should read "[,<table_constraint> ...]);"

Page 144:  "treated it as if it were a predefined view" should read "treating it as if it were a predefined view"

Page 147:  In question 16, "(Returned Data in Movie Rental contains NULL values)" should read "(Returned Date in Movie Rental contains NULL values)"

Page 172:  In question 18, "A seach CASE expression should be helpful here" should read "A searched CASE expression should be helpful here"

Page 175:  In the bullet item for NOT NULL contraints, "For an INSERT, you must provide values for any columns that have NOT NULL constraints." should read "For an INSERT, you must provide values for any columns that have NOT NULL constraints except for columns defined with a DEFAULT clause"; and "(those with NOT NULL constraints)" should read "(those with NOT NULL constraints and without DEFAULT values)"

Page 229:  "library of prepackage functions" should read "library of prepackaged functions"

Page 41:  The sentence beginning "In SQL Server 2005, there does not appear to be a tool called SQL Query Analyzer" may be replaced with this sentence:  "In SQL Server 2005, the functions of Query Analyzer have been merged into the SQL Server Management Studio."

Corrections to "Answers to Quizzes and Final Exams":

Chapter 1
  7. a, b, c, e

Chapter 2
  1. a, b, e

Chapter 4
  12.  SELECT MOVIET_TITLE, RETAIL_PRICE_DVD
         FROM MOVIE
        WHERE RETAIL_PRICE_DVD BETWEEN 19.99 AND 29.99
        ORDER BY RETAIL_PRICE_DVD;

Chapter 9
  11.  d, e
  19.  a, b, c, d, e
  20.  b, c, d, e

Chapter 11
   5.  a, c

Final Exam
   1.  d, e
  39.  a, d
  50.  a, b, d, e