如何用SQL为每一行均产生一个随机数

select cast(ceiling(rand(checksum(newid()))*10) as int) as RndId from 表名