1 declare @i int 2 set @i=0 3 while @i<76 4 begin 5 DECLARE @NumBegin Int=1000000 --随机数的最小值 6 DECLARE @NumEnd Int=10000000 --随机数的最大值 7 DECLARE @Decimal Int=0 --保留小数点几位 8 DECLARE @A Int= @NumBegin+round((@NumEnd-@NumBegin)*rand(),@Decimal) 9 DECLARE @B Int= @NumBegin+round((@NumEnd-@NumBegin)*rand(),@Decimal) 10 DECLARE @NumBegin1 Int=10000 --随机数的最小值 11 DECLARE @NumEnd1 Int=100000 --随机数的最大值 12 DECLARE @Decimal1 Int=0 --保留小数点几位 13 DECLARE @C Int= @NumBegin1+round((@NumEnd1-@NumBegin1)*rand(),@Decimal) 14 DECLARE @AA varchar(50) = CAST(@A AS varchar(50)) 15 DECLARE @BB varchar(50) = CAST(@B AS varchar(50)) 16 DECLARE @CC varchar(50) = CAST(@C AS varchar(50)) 17 DECLARE @STR varchar(50) = @AA+@BB+@CC 18 19 update [dbo].[Orders] 20 set OID = 'XNS'+@STR 21 WHERE ID=@i+1 22 23 update [dbo].[Orders_detail] 24 set OID = 'XNS'+@STR 25 WHERE ID=@i 26 27 set @i=@i +1 28 end 29 30 select * from [dbo].[Orders] 31 select * from [dbo].[Orders_detail]