Topic: SQL Server

Wrox's SQL Server 2005 Express Edition Starter Kit (0764589237) cover image

Wrox's SQL Server 2005 Express Edition Starter Kit

Rajesh George, Lance Delano
ISBN: 978-0-7645-8923-2
Paperback
384 pages
January 2006
This title is out-of-print and not currently available for purchase from this site.

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
28 Error in Text
ROW:6
COLUMN:Range/Size
10^38+1 to 10^38-1

should be:
-10^38+1 to 10^38-1
06/08/07
37 Error in Text
Tryout section, 4th paragraph, last row:
DELETE * FROM Inventory WHERE ID=1

should be :
DELETE FROM Inventory WHERE ID=1
08/11/08
38 Error in Text
The second sentence of the 5th paragraph reads, "Also there is some performance degradation during upgrades and deletes because ..."

upgrades

should be:

updates
03/17/2008
41 Errors in Text
In CREATE VIEW InventoryPublisherView AS
(SELECT * FROM Inventory AS I FULL OUTER JOIN Publisher AS P ON I.ID=P.InventoryID)

Column name in Publisher table reads:
ID

Should read:
PubID

AND

The first highlighted code reads:
USE testDB GO CREATE VIEW InventoryPublisherView AS (SELECT * FROM Inventory AS I FULL OUTER JOIN Publisher AS P ON I.ID=P.InventoryID)

Should read:
USE testDB GO CREATE VIEW InventoryPublisherView AS (SELECT I.ID, I.name, I.type, I.quantity, P.pubName FROM Inventory AS I FULL OUTER JOIN Publisher AS P ON I.ID=P.InventoryID)
04/14/2006
72 Error in Code
Line missing:
There should be a line with BindingSource.Position and BindingSource.Find.
11/20/06