Professional SQL Server 2005 Programming

ISBN: 978-0-7645-8434-3

Paperback

912 pages

December 2006

Professional SQL Server 2005 Programming (0764584340) 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
10	Error in Text under Rules: "Unlike rules, constraints aren't really objects... but rather pieces of metadata" then under defaults: "we have constraints which are objects, and rules, which are not objects but metadata Rob Vieira says "The second statement is incorrect the first is correct."	08/20/2008
64	Error in Code At the bottom of page 64, the syntax for the DELETE statement has a bracket mismatch. DELETE [TOP () [PERCENT] should be DELETE [TOP () [PERCENT] ]	11/13/08
74	Typo in Text "It is entirely possible to have to objects with the same name" should be "It is entirely possible to have two objects with the same name"	11/13/08
155	Error in Text The third line in the first paragraph reads: "Okay, the real question is one of whether you already understand the most basic tenants of relational database design yet or not." It should be "the most basic tenents."	11/12/08
169	Error in Text "blow" should be: "blob"	08/30/2007
450	Error in Code On page 450 of Professional SQL Server 2005 Programming, there begins a code block that is an improper carry forward from the 2000 edition of the book. The discussion is valid, and the results shown are from the proper code (as opposed to the code shown in the book). Correct code: USE AdventureWorks /* Build the table that we'll be playing with this time */ SELECT SalesOrderID, CustomerID INTO CursorTable FROM Sales.SalesOrderHeader WHERE SalesOrderID BETWEEN 43661 AND 43665 -- Declare our cursor DECLARE CursorTest CURSOR GLOBAL -- So we can manipulate it outside the batch SCROLL -- So we can scroll back and see the changes KEYSET TYPE_WARNING FOR SELECT SalesOrderID, CustomerID FROM CursorTable -- Declare our two holding variables DECLARE @SalesOrderID int DECLARE @CustomerID varchar(5) -- Get the cursor open and the first record fetched OPEN CursorTest FETCH NEXT FROM CursorTest INTO @SalesOrderID, @CustomerID -- Now loop through them all WHILE @@FETCH_STATUS=0 BEGIN PRINT CAST(@SalesOrderID AS varchar) + ' ' + CAST (@CustomerID AS varchar) FETCH NEXT FROM CursorTest INTO @SalesOrderID, @CustomerID END -- Now it's time to clean up after ourselves CLOSE CursorTest DEALLOCATE CursorTest DROP TABLE CursorTable	01/28/08
727	Typo second sentence under COPY_ONLY: For example, logs are differential... should read: For example, log and differential...	02/08/07
730-1	Error in Text The DBO_ONLY command has been replaced by the RESTRICTED_USER command. The DBO_ONLY is available only for backward compatibility reasons.	02/09/07
839	Typo in Text Notifying people interested in concerns... should be: Notifying people interested in concerts...	11/21/08