我这样
insert into myscore
select sd.stockid,cast( floor(rand()*100) as decimal(5,2))
from stock_t sd
怎么插入myscore的随机数全是一样的???
insert into myscore
select sd.stockid,cast( floor(rand()*100) as decimal(5,2))
from stock_t sd
怎么插入myscore的随机数全是一样的???
set @rd=cast( floor(rand()*100) as decimal(5,2))insert into myscore
select sd.stockid,@rd
from stock_t sd
select sd.stockid,cast( floor(rand(sd.stock_id)*100) as decimal(5,2))
from stock_t sd这样子貌似得到的数也不是很随机,好多重复的
select sd.stockid,cast( floor(rand()*100) as decimal(5,2)/sd.stock_id)
from stock_t sd
SELECT RAND(100), RAND(), RAND()
以下示例将产生由 RAND 函数生成的四个不同的随机数。
DECLARE @counter smallint;
SET @counter = 1;
WHILE @counter < 5
BEGIN
SELECT RAND() Random_Number
SET @counter = @counter + 1
END;
GO