• Early in the article you mention the benefit of creating a SELECT statement to preview the rows that will be updated. Here is a useful form for previewing the changes:

    UPDATE p SET

    --SELECT p.*,

    ProductName = 'WingDing'

    , Price = 19.27

    FROM Product p

    WHERE p.ProductName = 'WingDng'