试试这个:

SELECT RAND(convert(varbinary, newid()))*(b-a)+a magic_number 

a是较小的数，b是较大的数

很简单:

DECLARE @rv FLOAT;
SELECT @rv = rand();

这将把一个0-99之间的随机数放入表中:

CREATE TABLE R
(
    Number int
)

DECLARE @rv FLOAT;
SELECT @rv = rand();

INSERT INTO dbo.R
(Number)
    values((@rv * 100));

SELECT * FROM R

您是否在每一行中都有一个整数值，可以作为种子传递给RAND函数?

要得到1到14之间的整数，我相信这是可行的:

FLOOR( RAND(<yourseed>) * 14) + 1

RAND(CHECKSUM(NEWID()))

上面将生成一个(伪)随机数，介于0和1之间，不排除。如果在选择中使用，因为种子值每一行都在变化，它将为每一行生成一个新的随机数(但不保证每一行生成一个唯一的数字)。

当与10的上限组合时(产生数字1 - 10):

CAST(RAND(CHECKSUM(NEWID())) * 10 as INT) + 1

transact - sql批量文档:

演员():https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql 兰德():http://msdn.microsoft.com/en-us/library/ms177610.aspx (): http://msdn.microsoft.com/en-us/library/ms189788.aspx校验和 NEWID (): https://learn.microsoft.com/en-us/sql/t-sql/functions/newid-transact-sql

    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;

Update my_table set my_field = CEILING((RAND(CAST(NEWID() AS varbinary)) * 10))

1到10之间的数字。