例子:
DECLARE @i INT
DECLARE @money MONEY
DECLARE @month int SET @i=1 WHILE @i<40 BEGIN SET @money=rand()*100000 SET @month=-RAND()*10 INSERT INTO Charge (ID ,Date ,ChargeTypeID ,ChargeTypeName ,Money ,Remark ,CreatedBy ,CreatedTime) VALUES (48 ,dateadd(month,@month,getdate()) ,1 ,'' , @money ,N'花了'+CONVERT(VARCHAR,@money) ,'KK' ,GETDATE()) SET @i=@i+1
转载于:https://www.cnblogs.com/Lulus/p/7874187.html
相关资源:经典全面的SQL语句大全
转载请注明原文地址: https://win8.8miu.com/read-1498043.html