The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
| Version |
Location |
Description |
Submitted By |
Date submitted |
Date corrected |
| Printed |
Page 102
Figure 7-2 |
In figure 7-2 table, under page header, the second '4j' should be '0jjjj'.
Note from the Author or Editor:
yep. you are correct. Thanks |
TomX |
Mar 13, 2014 |
|
| PDF |
Page 128
1st paragraph + SQL Query that follows |
The text says:
In the previous example, the result set would include all order data that occurred between 5/1/2001 12 AM and 12/31/2007 12 AM. As such, it would not return anything that happened during the day of 12/31/2007 after midnight. If you were required to include the values for that data, you could write the query as follows:
SELECT
AccountNumber,
SalesOrderID,
OrderDate
FROM Sales.SalesOrderHeader
WHERE
OrderDate >= '5/1/2007 00:00:00' AND OrderDate<= '12/31/2007'
... but this is not true. The query still doesn't return anything during the day of 12/31/2007. Consider using the following query instead:
SELECT
AccountNumber,
SalesOrderID,
OrderDate
FROM Sales.SalesOrderHeader
WHERE
OrderDate >= '5/1/2007' AND OrderDate< '1/1/2008'
Note from the Author or Editor:
Thanks. This was corrected |
sam |
Feb 26, 2014 |
|
| PDF |
Page 209
United Kingdom |
page 209
In the following code snippet, the first SELECT statement calls the function with a single parameter. It succeeds because the second parameter is an optional input parameter.
SELECT dbo.GetEmployeeAge('5/26/1972')
this fails with error: An insufficient number of arguments were supplied for the procedure or function dbo.GetEmployeeAge.
Note from the Author or Editor:
You are correct the query needs to be modified to the following: SELECT dbo.GetEmployeeAge('5/26/1972', NULL) |
bruce whanya |
Nov 30, 2013 |
|
| Printed |
Page 53
|
The comment that introduces the T-SQL Code is wrong. The code does not create a database with a single data and log file.
The comment should read something like "Use this code to create a database schema using T-SQL"
Note from the Author or Editor:
Thanks for that catch. This will be updated in the next version. |
Tutu |
Nov 17, 2013 |
|
| Printed |
Page 91
Between steps 7 and 8 |
The Disable Indexes dialog box opens. Should we select the Indexes to disable before clicking OK?
Note from the Author or Editor:
In step seven on page 91 it states to right-click a specific index and select Disable. A step you have been added prior to that step indicating the selection of the index. |
Anonymous |
Aug 02, 2013 |
|
| Printed |
Page 67
Subhead between 22. and 1. |
The subhead reads: Add a computer column using T-SQL. The subhead should read: Add constraints using T-SQL.
Note from the Author or Editor:
You are correct. The subheading will be updated to constraints instead of computed columns |
Anonymous |
Aug 01, 2013 |
|
| Printed |
Page 52
Figure 5-2 |
Table name of the Departments table should be Department to remain consistent with the other tables and to maintain the stated standard.
Note from the Author or Editor:
Correct again. We will get the image updated to Department |
Anonymous |
Aug 01, 2013 |
|
| Printed |
Page 64
Step 2 |
Comment reads --Use this code to add the Gender column to the Employee table. The comment should read --Use this code to add the FullName column to the Employee table
Note from the Author or Editor:
You are correct and it will be updated to FullName. Thanks again |
Anonymous |
Aug 01, 2013 |
|
| Printed |
Page 67
Step 20 |
The instructions state ([Gender='Female' OR [Gender]='Male'). Note: bracket after first instance of Gender is missing; the field size for the Gender field is 1.
Should be written as ([Gender]='F' OR [Gender]='M')
Note from the Author or Editor:
Thanks, text will be changed to ([Gender]='F' OR [Gender]='M') |
Anonymous |
Aug 01, 2013 |
|
| Printed |
Page 29
Step 23 |
Right clicking on the project does NOT display the Deploy option...many other options are displayed including Publish but NOT Deploy
Note from the Author or Editor:
Instead of deploy it should have been publish. Thanks for pointing this out. Please email me at pleblanc@sqllunch.com if you have any questions or concerns regarding the book. |
Nicolas Lira |
Jun 06, 2013 |
|
| Printed, PDF |
Page 201
3rd paragraph from top |
QUOTED_INDENTIFIER option - obviously should be QUOTED_IDENTIFIER
Note from the Author or Editor:
You are correct. Should be QUOTED_IDENTIFIER. Thanks for pointing this out. Thanks for reading the book. Please feel free to email me at pleblanc@sqllunch.com if you have any for questions or concerns. |
Marek Wlodarz |
May 25, 2013 |
|
| Printed |
Page 29
Step 22 |
We are told to select "Deploy" from the menu after right-clicking the project in the Solutions Explorer. But "deploy" isn't an option in that menu.
Note from the Author or Editor:
Instead of deploy it should have been publish. Thanks for pointing this out. Please email me at pleblanc@sqllunch.com if you have any questions or concerns regarding the book. |
Anonymous |
May 24, 2013 |
|
| Printed |
Page 67
between printed steps 14 and 15 |
An important step is missing on page 67 between printed steps 14 and 15 regarding adding unique constraints to an existing table. In my understanding, the following step should be added:
14b. Locate and click on the Columns property and then click on the ellipsis next to EmployeeID (ASC). On the next window, select SocialSecurityNumber under the Column Name drop-down list. Click OK.
Note from the Author or Editor:
This should be added directly in the middle of 14 and 15.
15. Locate and click on the Columns property and then click on the ellipsis next to EmployeeID (ASC). On the next window, select SocialSecurityNumber under the Column Name drop-down list. Click OK.
Please adjust numbering. |
Motiar Rahman |
May 09, 2013 |
|
| Printed |
Page 40
step 13 |
I resolved the error I previously mentioned... I attempted to create a different kind of SQL project, (some kind of "online" template). It then prompted me to install some component of SQL Data Tools. I then restarted SQL Data tools, and was able to follow the book at that point.
On page 40:
Step 12 tells you to click OK, thereby closing the dialog box. Step 13 then tells you to select an option in the dialog that you just closed.
Minor comments about the next section:
(a) Step 1 is a bit vague. "Open the query editor"... I was unsure whether you wanted me to click "New Query", or save a new script in the "Queries" folder, as on page 27. Perhaps we need a little more hand-holding this early in the book, while we are unfamiliar with SSMS. That seems to be the MS Press SBS style.
(b) After entering the query, do you want us to execute it? After flipping forward in the book, I see that your usual pattern is to say "Enter and Execute," so I'll assume that from now on. But since this was the first script in your book, that minor ommission caused me some confusion.
(c) page 41 refers to an argument "database_name" that is not explicitly mentioned in the query.
Note from the Author or Editor:
I have sent in the updates. Thanks for providing the information
On page 40, step 13 should be removed
Step 1 on page 40 should read Click the button labeled New Query to open the query editor in SSMS
Step 2 on page 30 should read Enter and execute the following T-SQL code: |
Adam C |
May 05, 2013 |
|
| Printed |
Page 28
step 3&7 |
I have followed the instructions through the book so far, and in step 3, "SQL Server Development Settings" is not an option available to me. I do have the other 4 depicted in the screen grab. In step 7, "SQL Server Database Project" is also not available. Is it possible that the authors installed some additional software options, not mentioned in the previous steps?
Note from the Author or Editor:
Thank you for catching that. A not will be added to this section. The first time using SQL Server Data tools you will need to install the Database Project from the Web. Therefore, in step 3 you may not see SQL Server Development Settings. Also, in step 7 you will select Microsoft SQL Server Data Tools (Web Install). This will install the database project template. Once complete restart SQL Server Data Tools and you should be able to create a database project. If you have any further questions please feel free to email me at pleblanc@sqllunch.com. Thanks for buying the book. |
Adam C |
May 05, 2013 |
|
| Printed, PDF |
Page back cover
bullet points |
- last point on cover's back reads: "Build your first Windows? Store app" - there is nothing in this book about Windows Store
Note from the Author or Editor:
You are correct. I will have that fixed. |
Adam Zaremba |
Apr 29, 2013 |
|