Use SQL Server to generate random numbers

-- Create view myview as select Re = rand () -- custom function: Get the random number of the specified range create function mydata (@ A int, @ B INT) returns decimal) 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 =. number from (select innerid, DBO. mydata (1,100) number from ba_product) as a, ba_product B where. innerid = B. innerid