使用:
- 查询:
select *, ABS(CHECKSUM(NewId())) % 20 + 65 as new_score from training_score;
- 修改:
update training_score set score = ABS(CHECKSUM(NewId())) % 20 + 65 where score is null;
参考:
使用:
select *, ABS(CHECKSUM(NewId())) % 20 + 65 as new_score from training_score;
update training_score set score = ABS(CHECKSUM(NewId())) % 20 + 65 where score is null;
参考: