菜鸟求SQL语句 - MS-SQL Server / 疑难问题

想在PE_CommonModel表的Hits字段填入8000-20000的随机数字。并替换原来的数字
求SQL语句，数据库是SQLSERVER

---

select ceiling (rand()*(20000-8000)+8000)

---

SQL code:
update tb set col=ceiling (rand()*(20000-8000)+8000)

---

SQL code:
update tb set col=(cast(ceiling (rand()*(20000-8000)+8000) as int)

---

引用

SQL code
update tb set col=ceiling (rand()*(20000-8000)+8000)

SQL code:
declare @t table(id int)
insert @t select 1
insert @t select 2
insert @t select 3
update @t set id=2000+rand(checksum(newid()))*(8000-2000)
select * from @t
/*
id
-----------
6807
6607
2054
*/
update @t set id=ceiling (rand()*(20000-8000)+8000)
select * from @t
/*
id
-----------
18878
18878
18878
*/

---

SQL code:
select cast(ceiling (rand()*(20000-8000)+8000) as int)
/*-----------
14423

(1 行受影响)
*/

---

引用

引用 2 楼 fredrickhu 的回复:
SQL code
update tb set col=ceiling (rand()*(20