Errata for Programming Microsoft® SQL Server® 2008
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.
Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update
Incorrect information regarding the WAITFOR statement
On page 43, the "The WAITFOR Statement" section contains incorrect information.
"In SQL Server 2000, WAITFOR waited for a specified duration or a supplied datetime value. Starting with SQL Server 2005, as with the TOP enhancements, you can use WAITFOR with a SQL expression. You can essentially use the WAITFOR function to wait for a T-SQL statement to affect at least one row. (You can also set a time-out on that SQL expression.) You can specify WAITFOR to wait not only in SELECT statements but also in INSERT, UPDATE, DELETE, and RECEIVE statements. In essence, SELECT statements wonâ€™t complete until at least one row is produced, and data manipulation language (DML) statements wonâ€™t complete until at least one row is affected.
Here is the syntax:
WAITFOR() [,TIMEOUT ]
This feature provides an alternative to polling. For example, you can use WAITFOR to select all the records in a log or a queue table, as shown here:
WAITFOR (SELECT * FROM MyQueue)"
"In SQL Server 2000, WAITFOR waited for a specified duration or a supplied datetime value. Starting with SQL Server 2005, as with the TOP enhancements, you can use WAITFOR with a RECEIVE statement.
Here is the syntax:
WAITFOR() [,TIMEOUT ]"
Microsoft Press is committed to providing informative and accurate
books. All comments and corrections listed above are ready for
inclusion in future printings of this book. If you have a later printing
of this book, it may already contain most or all of the above corrections.
||May 06, 2010