62,074
社区成员
发帖
与我相关
我的任务
分享
select cast( floor(rand()*15) as int)+15
DECLARE @recordCount int
DECLARE @counter smallint
SET @counter = 1
SELECT @recordCount=count(*) FROM a
WHILE @counter < @recordCount
BEGIN
UPDATE A SET A1=A1+RAND(@counter)
--SELECT RAND(@counter) Random_Number
SET NOCOUNT ON
SET @counter = @counter + 1
SET NOCOUNT OFF
END
GO