感觉用默认约束带入可能好点,暂时没想到好办法alter table T1 add constraint df_num default convert(numeric(4,2),RAND()*2+10) for A
While (Select COUNT (1) From T1 Where A = 0) > 0 Begin Update T1 Set A = Convert(Decimal(9,2),Convert(Int,Floor(RAND()*10000)) %2 +10 + RAND()) Where ID = (Select Top 1 ID From T1 Where A = 0) End
--假设T1表的关键字是ID,并且A字段初始值为0 While (Select COUNT (1) From T1 Where A = 0) > 0 Begin Update T1 Set A = Convert(Decimal(9,2),Convert(Int,Floor(RAND()*10000)) %2 +10 + RAND()) Where ID = (Select Top 1 ID From T1 Where A = 0) End
生成10到12之间的二位小数(这应该最多就2、300个数字吧)
用一个UPDATE好像不行,估计要用循环一个一个的生成。
add constraint df_num
default convert(numeric(4,2),RAND()*2+10) for A
Begin
Update T1 Set A = Convert(Decimal(9,2),Convert(Int,Floor(RAND()*10000)) %2 +10 + RAND())
Where ID = (Select Top 1 ID From T1 Where A = 0)
End
While (Select COUNT (1) From T1 Where A = 0) > 0
Begin
Update T1 Set A = Convert(Decimal(9,2),Convert(Int,Floor(RAND()*10000)) %2 +10 + RAND())
Where ID = (Select Top 1 ID From T1 Where A = 0)
End