update TableNameset RandID=(select cast(ceiling(rand(checksum(newid()))*6) as int) as sid ) where 条件
update TableNameset RandID=(select cast(ceiling(rand(checksum(newid()))*6) as int) as sid ) where 条件
update TableNameset RandID=(select cast(ceiling(rand(checksum(newid()))*6) as int) as sid ) where 条件