²ËÄñÇó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