sql 循环+随机数创建数据

--循环

WHILE @i<40

BEGIN

……

end

--随机数

SET @money=rand()*100000

 

例子:

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   --不要忘记

end