【求助】求一条SQL语句
username password
AAA 11111
BBB 11111
CCC 11111
DDD 11111
将passwoord列的初始值全部随机为某2个数之间的值，这张表的数据是大量的，
请问怎么解决？
谢谢
[解决办法]
比如插入20000-50000的值：
create table test(username varchar(10),password int)
insert test select 'asdfj',null
insert test select 'asdfj',null
insert test select 'asdfj',null
insert test select 'asdfj',null
insert test select 'asdfj',null
insert test select 'asdfj',null
insert test select 'asdfj',null
insert test select 'asdfj',null
insert test select 'asdfj',null
insert test select 'asdfj',null
update test set password=cast((50000-20000)*rand(checksum(newid())) as int)+20000
