为数据库生成某个字段充填随机数的存储过程 |
本文标签:字段,随机数 复制代码 代码如下: Declare @CurrentRecord int,@BeginNum int, @EndNum int, @TotalCount int,@Value int set @BeginNum=0 set @EndNum=500 set @TotalCount=80 set @CurrentRecord=1 While @CurrentRecord<=@TotalCount Begin set @Value= @BeginNum+(@EndNum - @BeginNum)*rand() update [tableName] set [columnName] = @Value where [IDColumnName] = @CurrentRecord set @CurrentRecord=@CurrentRecord+1 End |