使用:
- 查询:
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;
参考:
© 版权声明
文章版权归作者所有,未经允许请勿转载。
THE END
使用:
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;
参考:
暂无评论内容