WILEY

Publishers since 1807

Wiley - Publishers Since 1807

United States Change Location

cart.gif CART |  MY ACCOUNT |  CONTACT US |  HELP    
Cover image for product 0764584332
Beginning SQL Server 2005 Programming
ISBN: 978-0-7645-8433-6
Paperback
720 pages
February 2006
US $39.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
  • Related Websites
  • 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
Error in Reference
...pubs and Northwind are only installed as part of a separate installation that can be downloaded from Microsoft. See Appendix F (online) for more information on how to get them installed on your practice system. There is no Appendix F. It's Appendix E.
07/07/2008
Code Replacement
Code Replacement for this title can be found at:
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584332,descCd-download_code.html
04/20/2006
11 Error in Text
Text reads:
"(...the same way we have constraints, which are objects, and rules, which are not objects but metadata.)"

Should read:
"(...the same way we have rules, which are objects, and constraints, which are not objects but metadata.)"
08/19/2006
28, 31 Error in Figures
Page 28, the connect to server figure reflects connecting to server
Schweitzer.
should be:
(local)

AND

Page 31, Try it out figure shows Schweitzer
should be:
(local)
09/11/07
34-38 Error in Figure References
"Results In Text" shown in 2-11, should be 2-12 "Show Execution Plan" shown in 2-12, should be 2-13 "re-run the query" shown in 2-13, should be 2-14 Figure 2-14 shows how to select the AdventureWorks database, should not be there.
03/20/08
54 Error in Instruction
re:
SELECT OrderID, SUM(Quantity)
From [Order Details]
Where OrderID BETWEEN 11000 AND 11002
GROUP BY OrderID

Text reads, "If we didn't supply the GROUP BY clause, the SUM would
have been of all the values in all of the rows for the named column."

BUT

If you remove the "GROUP BY OrderID" line, an error occurs.

INSTEAD should be:
SELECT SUM(Quantity)
From [Order Details]
Where OrderID BETWEEN 11000 AND 11002
5/22/06
55 Error in Text
85 X 3 = 28.33

should be:
85 / 3 = 28.33
03/20/08
146-147 Error in Text
If you look at pages 146 - 147 at figures 5-6 and 5-8, you will see the CustomerName field is set to varbinary(30).

The images should show it is varchar(30).
06/30/2006
153 Error in Text
First paragraph under Entity Constraints reads:
"... value for a column or a combination of problems."

Should read:
"combination of columns"
06/30/2006
233 Error in Figures 8-13 adn 8-21
Line reads: "I can then add in my new column, and reset the Primary Key as shown in Figure 8-13 (select both rows, right click and choose Set Primary Key)." Now, when I do this, my table shows key icons on both the CustomerID column and the Sequence columns, while the example Figure 8-13 (and subsequent figure 8-21) still shows the Key icon only on the CustomerID column. This leads me the figure examples should show both key icons.
03/17/08
336 Error in Text
Code paragraph says:
"/* First, we’ll declare to variables."

should be:
"/* First, we’ll declare two variables."
08/12/2007