Should be: Resource The Resource database is a hidden, read-only database that was added as of SQL Server 2005 and it holds the definitions of all system objects. When you query system objects in a database, they appear to reside in the sys schema of the local database, but in practice their definitions reside in the Resource database.

Error: This paragraph would have been relevant had the val attribute been of an integer type, but in practice it is of a decimal type already. Hence this paragraph should be removed.

Should be: SELECT ... NTILE(10) ...

Should be:  + (Positive), – (Negative), + (Add), + (Concatenate), – (Subtract)

Should be:  col2/col1 > 2

Should be: The storage requirements for the last three data types in Table 2-1 (TIME, DATETIME2, and DATETIMEOFFSET) depend on the precision you choose. You specify the precision as an integer in the range 0 to 7 representing the fractional second precision. For example, TIME(0) means 0 fractional second precision—in other words, one-second precision. TIME(3) means one-millisecond precision, and TIME(7) means 100-nanosecond precision. If you don’t specify a fractional second precision, SQL Server assumes 7 by default with all three aforementioned types.

Should be: SQL Server defines precedence among datatypes, and will usually implicitly convert the operand that has lower datatype precedence to the one that has higher precedence.

Should be: DATEPART( part, dt_val )

Should be: DATENAME( part, dt_val )

Should be: Because the request involves activity in the year 2007, the query should have a WHERE clause with the appropriate date range filter (orderdate >= '20070101' AND orderdate < '20080101').

Should be: This query returns the order ID 10739. The outer row’s order ID—10248—is compared with the inner one—10739—and because there’s no match in this case, the outer row is filtered out.

Should be: Write an outer query against the Employees table returning employees whose IDs do not appear in the set of employee IDs returned by the subquery.

Should be: Write an outer query against the Customers table that filters only customer rows where the country does not appear in the set of countries returned by the subquery.

Should be: "...because the same country can have more than one customer."

Should be: SELECT TOP(100) PERCENT

Should be: "...before the rows from Suppliers,..."

Should be:
orderid     orderdate  empid       custid qty
----------- ---------- ----------- ------ -----------
10001       2007-12-24 2           A      12
10005       2007-12-24 1           B      20
10006       2008-01-18 1           C      14
20001       2008-02-12 2           B      12
20002       2009-02-16 1           C      20
30001       2007-08-02 3           A      10
30003       2009-04-18 2           B      15
30004       2007-04-18 3           C      22
30007       2009-09-07 3           D      30
40001       2008-01-09 2           A      40
40005       2009-02-12 3           A      10

Should be: For example, all rows where grpemp is 0 and grpcust is 0 are associated with the grouping set (empid, custid).

Should be: The grouping set (a, c) is represented by the integer 5 (0×8 + 1×4 + 0×2 + 1×1), and so on.

Problem: Confusing as written.

Should be: INSERT statements must specify values for any columns in the underlying table that do not have implicit values. A column can get a value implicitly if it allows NULLS, has a default value, has an IDENTITY property, or is typed as ROWVERSION.

Should be: However, with some problems using a table expression is the only option.

Should be: Only once. Should remove third part of the output from the page.

Should be: As for the blocker, in this example you can see the statement that caused the problem, but keep in mind that the blocker may continue working and that the last thing you see in the code isn’t necessarily the statement that caused the trouble.

Should be:

  BACKUP DATABASE TSQLFundamentals2008
    TO DISK = 'C:\Temp\TSQLFundamentals2008_Diff.BAK' WITH INIT, DIFFERENTIAL;