使用newid ()

select newid()

或者可能是这个

select binary_checksum(newid())

尝试在RAND中使用种子值(seedInt)。RAND()每条语句只执行一次，这就是为什么每次都看到相同的数字。

使用newid ()

select newid()

或者可能是这个

select binary_checksum(newid())

如果你需要一个特定的随机数你可以使用递归CTE:

;WITH A AS (
        SELECT 1 X, RAND() R
    UNION ALL
        SELECT X + 1, RAND(R*100000) --Change the seed
        FROM A
        WHERE X < 1000 --How many random numbers you need
    )
SELECT
    X
    , RAND_BETWEEN_1_AND_14 = FLOOR(R * 14 + 1)
FROM A
OPTION (MAXRECURSION 0) --If you need more than 100 numbers

    DROP VIEW IF EXISTS vwGetNewNumber;
    GO
    Create View vwGetNewNumber
    as
    Select CAST(RAND(CHECKSUM(NEWID())) * 62 as INT) + 1 as NextID,
    'abcdefghijklmnopqrstuvwxyz0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'as alpha_num;

    ---------------CTDE_GENERATE_PUBLIC_KEY -----------------
    DROP FUNCTION IF EXISTS CTDE_GENERATE_PUBLIC_KEY;  
    GO
    create function CTDE_GENERATE_PUBLIC_KEY()
    RETURNS NVARCHAR(32)
    AS 
    BEGIN
        DECLARE @private_key NVARCHAR(32);
        set @private_key = dbo.CTDE_GENERATE_32_BIT_KEY();
        return @private_key;
    END;
    go

---------------CTDE_GENERATE_32_BIT_KEY -----------------
DROP FUNCTION IF EXISTS CTDE_GENERATE_32_BIT_KEY;  
GO
CREATE function CTDE_GENERATE_32_BIT_KEY()
RETURNS NVARCHAR(32)
AS 
BEGIN
    DECLARE @public_key NVARCHAR(32);
    DECLARE @alpha_num NVARCHAR(62);
    DECLARE @start_index INT = 0;
    DECLARE @i INT = 0;
    select top 1 @alpha_num = alpha_num from vwGetNewNumber;
        WHILE @i < 32
        BEGIN
          select top 1 @start_index = NextID from vwGetNewNumber;
          set @public_key = concat (substring(@alpha_num,@start_index,1),@public_key);
          set @i = @i + 1;
        END;
    return @public_key;
END;
    select dbo.CTDE_GENERATE_PUBLIC_KEY() public_key;

select round(rand(checksum(newid()))*(10)+20,2)

这里的随机数在20和30之间。 四舍五入最多会给出两位小数点后的数字。

如果你想要负数，你可以这样做

select round(rand(checksum(newid()))*(10)-60,2)

那么最小值将是-60，最大值将是-50。