用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_Productupdate 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