Should be: following are the tables with the shading of the primary key columns:

Table 3-1 A Table Before 1NF

Table 3-2 A Table in 1NF

Table 3-3 The Orders Table in 2NF

Table 3-4 The OrderDetails Table in 2NF

Table 3-5 The Customers Table in 3NF

Table 3-6 The Orders Table in 3NF

Table 3-7 The OrderDetails Table in 3NF

Table 3-8 The Products Table in 3NF

Table 3-9 The Imaginary Orders Table

Table 3-10 The Orders Table in BCNF: First Solution

Table 3-11 The Orders Table in BCNF: Second Solution

Table 3-12 The Employees-Projects-Activities Table

Table 3-13 The Employees-Projects-Activities Table with Multivalued Columns

Table 3-14 The Employees-Projects Table

Table 3-15 The Employees-Activities Table

Table 3-16 The Employees-Projects-Activities Table

Table 3-17 The Projects-Activities Table

Currently: There's a pointer to first 1:47120 that shouldn't be there.

Should be: Mistaken pointer should be removed.

WITH cte_name
AS
(
  cte_query
)
outer_query_referring_to_cte_name

Should be:

WITH <cte_name>[( <target_column_list> )]
AS
(
  <inner_query_defining_cte>
)
<outer_query_against_cte>;

Should be: <ranking_function> OVER([PARTITION BY <col_list>] ORDER BY <col_list>)

Should be: cnt

Should be: WHERE <where_predicate>

Should be: WHERE <where_predicate>

WITH EXCEPT_ALL
AS
(
  SELECT
    ROW_NUMBER() 
      OVER(PARTITION BY country, region, city
           ORDER     BY (SELECT 0) AS rn,
    country, region, city
    FROM HR.Employees

  EXCEPT

  SELECT
    ROW_NUMBER() 
      OVER(PARTITION BY country, region, city
           ORDER     BY (SELECT 0) AS rn,
    country, region, city
  FROM Sales.Customers
)
SELECT country, region, city
FROM EXCEPT_ALL;

Error: missing closing parenthesis after (SELECT 0) in both ROW_NUMBER expressions.

Should be:

WITH EXCEPT_ALL
AS
(
  SELECT
    ROW_NUMBER() 
      OVER(PARTITION BY country, region, city
           ORDER     BY (SELECT 0)) AS rn,
    country, region, city
    FROM HR.Employees

  EXCEPT

  SELECT
    ROW_NUMBER() 
      OVER(PARTITION BY country, region, city
           ORDER     BY (SELECT 0)) AS rn,
    country, region, city
  FROM Sales.Customers
)
SELECT country, region, city
FROM EXCEPT_ALL;

2010-01-12 /
Erland Sommarskog, Plamen Ratchev

Correction: T-SQL does support qualifying a column with a table variable name provided that you delimit it, e.g., [@MyOD].orderid.

Should be: Temporary Tables and Table Variables

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: <query> OPTION(OPTIMIZE FOR(@p1 UNKNOWN, @p2 UNKNOWN, ...);

Should be: <query> OPTION(OPTIMIZE FOR UNKNOWN);

Problem: Last statement is an editorial comment and made it to the text by mistake. The statement should be ignored.

Should be: For encapsulation purposes, I’ll create three stored procedures: one that sets the signal, one that clears it, and one that returns it.

Should be: What you end up getting in @rc is the number of rows affected by the first assignment (namely 1), instead of the number of rows affected by the suspect statement.