Wrox Home  
Search

Topic: SQL Server

Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (0470257032) cover image

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Paul Turley, Dan Wood
ISBN: 978-0-470-25703-6
Paperback
676 pages
December 2008
Other Available Formats: E-book
If you are an instructor, you may request an evaluation copy for this title.
Paperback Version: US $39.99 Add to Cart

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
9 Error in Text
On page 9 under decimal type, the parenthetical scientific notation to the all 9s string should be +10^38 - 1
10/13/09
217 Error in Code
Beginning T-SQL, page 217, exercise 1 asks for all average weight of all touring bikes with a list price over $2,500.

The code provided ignores list price and averages the weight of the 22 touring bikes sold by Adventure Works Cycles. In fact, there are no touring bikes priced over $2,500.
12/30/2010
10 315 Error in Code
Currently reads:

CREATE PROCEDURE spUpd_MyContacts
    @ContactID      int
  , @FirstName      nvarchar(50)
  , @LastName       nvarchar(50)
  , @Phone          nvarchar(25)
AS
   UPDATE MyContacts 
   SET FirstName = @FirstName
     , LastName = @LastName
     , Phone = @Phone

spUpd_MyContacts 5, 'Betrice', 'Rubble', '(222) 234-7654'

Should be:

CREATE PROCEDURE spUpd_MyContacts
@ContactID int
, @FirstName nvarchar(50)
, @LastName nvarchar(50)
, @Phone nvarchar(25)
AS
UPDATE MyContacts 
SET FirstName = @FirstName
, LastName = @LastName
, Phone = @Phone
WHERE ContactID = @ContactID
11/15/2011
503 Error in Text
At the bottom of the page, after keyword UNION the keyword SELECT is missing. The code should read:

SELECT -1 AS ProductCategoryID, '(All Categories)' AS Name
UNION
SELECT ProductCategoryID, NAME
FROM Production.ProductCategory
ORDER BY Name
10/12/09
Printer-Ready Version   Share This
With you wherever you go: pdf + ePub + kindle -- DRM-free