如题,小弟数据库里有一个ItemResult字段,我想在这个字段里更新0.02-0.52之间随机填充两位小数,应该怎么用命令?(最好别是储存过程或者游标,暂时这些我不太会)还请各位大大指点~
------解决思路----------------------
update table_name set ItemResult = (
select cast(abs(checksum(newid())%100)/100.00 as decimal(4,2)))
where id BETWEEN 1000 AND 2000 AND XXDM='050103'
------解决思路----------------------
UPDATE TB
SET ItemResult=CAST(CAST((RIGHT(ABS(CHECKSUM(NEWID())),2)/99.*76+4)AS INT)/10. AS DECIMAL(4,1))
WHERE id BETWEEN 1000 AND 2000 AND XXDM='050103'
对比一下，你就看出来了