10-variables-2batches.sql

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

DECLARE @MyDate datetime, @CurrPriceInCents money
SET @MyDate = GETDATE()
SELECT @CurrPriceInCents = CurrentPrice * 100
  FROM ShareDetails.Shares
 WHERE ShareId = 2
GO
SELECT @MyDate,@CurrPriceInCents