Errata

Learning SQL on SQL Server 2005

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