关于exec中不能有变量运算的问题

DECLARE @i INT
SET @i=1
DECLARE @msg NVARCHAR(100),@nowdate DATETIME,@newdate DATETIME,@money DECIMAL(14,2)
SET @nowdate=CONVERT(DATETIME,'2010-12-11')
WHILE @i<=10000
BEGIN
    SET @newdate=DATEADD(DAY,ROUND(RAND()*200,0),@nowdate)
    SET @money=RAND()*200
    exec c_insertAccount 38,@newdate,1,'pzh',1,@money,0,1,2,1,@nowdate,@msg output
    SET @i=@i+1
    SELECT @i
END

转载于:https://www.cnblogs.com/hzq3554055/archive/2009/10/16/1584326.html