WILEY

KNOWLEDGE FOR GENERATIONS

WILEY - KNOWLEDGE FOR GENERATIONS

United States Change Location

cart.gif CART |  MY ACCOUNT |  CONTACT US |  HELP    
Cover image for product 0764589237
Wrox's SQL Server 2005 Express Edition Starter Kit
ISBN: 978-0-7645-8923-2
Paperback
384 pages
January 2006
US $29.99 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

Other Available Formats: Adobe E-Book
  • Description
  • Table of Contents
  • Author Information
  • Errata
  • Download

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