用sql server生成随机数

[sql]

--创建视图

create view myview as select re=rand()

--自定义函数:取得指定范围的随机数

create function mydata(

@a int, www.2cto.com

@b int)

returns decimal(18,2)

begin

declare @r decimal(38,0)

select @r=cast(re*(@b-@a)+@a as decimal(38,0)) from myview

return(@r)

end

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

作者 chinaboykai