如何巧妙利用SQL Server的EXISTS结构（3）

IF EXISTS

(

      SELECT * FROM SalesHistory

      WHERE SaleDate = '1/1/2001' AND

            Product = 'Computer' AND 

            SalePrice = 1000

)

      UPDATE TOP(1) SalesHistory

      SET SalePrice = 1100

      WHERE SaleDate = '1/1/2001' AND

            Product = 'Computer' AND 

            SalePrice = 1000
ELSE
      INSERT INTO SalesHistory

      (Product, SaleDate, SalePrice)

      VALUES

      ('Computer', '1/1/2001', 1100)