CREATE TABLE t1 ( DB int ) INSERT INTO t1 VALUES ( null) INSERT INTO t1 VALUES ( null) INSERT INTO t1 VALUES ( null) declare @no int set @no=abs(CHECKSUM(NEWID())%1000000) update t1 set DB=@no,@no=abs(CHECKSUM(NEWID())%1000000+1)select * from t1 /* DB ------ 629722 712064 395330
update tb set pwd = cast(RAND() * 1000000 as int)
update t1 set pwd=abs(CHECKSUM(NEWID())%1000000+1)
(
DB int
)
INSERT INTO t1 VALUES ( null)
INSERT INTO t1 VALUES ( null)
INSERT INTO t1 VALUES ( null)
declare @no int
set @no=abs(CHECKSUM(NEWID())%1000000)
update t1 set DB=@no,@no=abs(CHECKSUM(NEWID())%1000000+1)select * from t1
/*
DB
------
629722
712064
395330
set pwd = cast(RAND() * 1000000 as int)
这一句是直接将pwd字段所有的值都更新为同一随机数,我要的是每条记录都获取到不同的随机数。请问用 游标 的方式可以做到吗?该如何写语句哪?我自己试了试,没弄出来,还请高手指点,感激不尽!