1-maxsharepriceexample.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 14 行

ALTER TABLE ShareDetails.Shares
ADD MaximumSharePrice money

DECLARE @MaxPrice money
SELECT @MaxPrice = MAX(Price)
    FROM ShareDetails.SharePrices
  WHERE ShareId = 1
SELECT @MaxPrice

UPDATE ShareDetails.Shares
SET MaximumSharePrice = @MaxPrice
WHERE ShareId = 1