Errata for Learning SQL on SQL Server 2005
Submit your own errata for this product.
The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| Printed |
Page xi
Last sentence first paragraph |
...faster then ever before.
should be
...faster than ever before.
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page xvi
at the end of the acknowledgements |
[Note from author]
I would like to add the following sentence to the preface on page xvi as a
final separate paragraph:
Finally, I would like to thank Jawahar Puvvala, John Vacca, Deac Lancaster
and Kevin Kline for their helpful comments on the manuscript.
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 19
Towards bottom of page |
USE Student
SELECT
FROM Student
should be
USE Student_course
SELECT
FROM Student
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 29
Second paragraph |
You may find it odd that a someone working with...
should be
You may find it odd that someone working with...
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 29
5th paragraph, last sentence. |
"The only field in the Dependent table that cannot be null is STNO."
Should read.
"The only field in the Dependent table that cannot be null is PNO."
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 36
Paragraph 1, Last line, words 7 and 8 |
Says "would you" instead of "you would"
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 50
First paragraph |
You say:
... (we discuss multi-table queries in Chapter 4 onward),
and then two sentences later you say:
We will explore multi-table queries in future chapters.
This is redundant. I would drop the second reference and stick with the
"Chapter 4 onward" one.
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 54
First bulleted item in middle of page |
inclues
should be
includes
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 64
2nd paragraph |
There is a syntax error in the sample syntax given for the "CREATE TABLE" command. There is an extra comma which, if used, will create invalid code. The code as printed in the 1st edition of the book reads:
CREATE TABLE Tablename
(column_name type, column_name, type, .....)
It should read:
CREATE TABLE Tablename
(column_name type, column_name type, .....)
|
Anonymous |
|
Aug 01, 2007 |
| Printed |
Page 220
First paragraph |
Reads: "For every students..."
Should read: "For every student..."
|
Anonymous |
|
Aug 01, 2007 |
|
| |
