Beginning SQL Server 2005 Programming

ISBN: 978-0-7645-8433-6

Paperback

720 pages

February 2006

Beginning SQL Server 2005 Programming (0764584332) cover image

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.

Page	Details	Date
	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
111	Typo in Text At the end of the 4th paragraph: (and any other SQL Server object for that matter Should be (and any other SQL Server object for that matter).	2/10/09
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
193	Typo in Text In the first sentence under the "Correlated Subqueries in the SELECT List" heading: Subqueries can also used... Should be Subqueries can also be used...	2/12/09
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
619	Error in Chapter Reference the CONTAINSTABLE & FREETEXTTABLE System Functions refer to more information about usage of each in Chapter 26. Full Text Search is only covered in the Professional title (9780764584343 Professional SQL Server 2005 Programming); there is no chapter 26 in Beginning.	07/30/08