用sql server生成随机数
--创建视图create view myview as select re=rand()
--自定义函数:取得指定范围的随机数
create function mydata(
@a int,
@b int)
returns decimal(18,2)
as
begin
declare @r decimal(38,0)
select @r=cast(re*(@b-@a)+@a as decimal(38,0)) from myview
return(@r)
end
go
select InnerID,dbo.mydata(100,1000) number from ba_Product
update ba_Product set PremiumNew=a.number
from (select InnerID,dbo.mydata(1,100) number from ba_Product) as a
,ba_Product b where a.InnerID=b.InnerID
页:
[1]