ALTER FUNCTION [dbo].[ufn_Random]( @A INT, @B INT) RETURNS INTASBEGIN/*功能:生成随机数*/ DECLARE @M INT,@N INT,@R DECIMAL(18,2) SELECT @M=0,@N=1 SELECT @R=RandValue*(@A-@B)+@B FROM VW_RAND SET @R=CAST(ROUND(@R,0) AS INT) RETURN(@R) END
本文共 311 字,大约阅读时间需要 1 分钟。
ALTER FUNCTION [dbo].[ufn_Random]( @A INT, @B INT) RETURNS INTASBEGIN/*功能:生成随机数*/ DECLARE @M INT,@N INT,@R DECIMAL(18,2) SELECT @M=0,@N=1 SELECT @R=RandValue*(@A-@B)+@B FROM VW_RAND SET @R=CAST(ROUND(@R,0) AS INT) RETURN(@R) END
转载于:https://www.cnblogs.com/GarsonZhang/p/3184028.html