sqlserver 不重復(fù)的隨機(jī)數(shù)

usp_RandomNumber
CREATE PROCEDURE [dbo].[usp_RandomNumber]
(
@Len INT = 1, --隨機(jī)數(shù)位數(shù)
@Rows INT = 1 --隨機(jī)筆數(shù)
)
AS
BEGIN
DECLARE @T AS TABLE([Random Number] VARCHAR(MAX))
DECLARE @L INT = 1, @R INT = 1
WHILE @R = @Rows
BEGIN
DECLARE @RN varchar(MAX) = ''
WHILE @L = @Len --隨機(jī)產(chǎn)生每個(gè)隨數(shù)的位數(shù)
BEGIN
SET @RN = @RN + CHAR(ROUND(RAND() * 9 + 48,0))
SET @L = @L + 1
END
--如果產(chǎn)生相同的隨機(jī)數(shù)，將不會存儲
IF NOT EXISTS(SELECT [Random Number] FROM @T WHERE [Random Number] = @RN)
BEGIN
INSERT INTO @T SELECT @RN --INSERT INTO @T ([Random Number])VALUES (@RN)
SET @R = @R + 1 --記錄總共產(chǎn)生了幾筆隨機(jī)數(shù)
SET @L = 1 -- 每產(chǎn)生完一個(gè)隨機(jī)數(shù)之后，將隨機(jī)數(shù)的位數(shù)初始化為1
END
END
SELECT [Random Number] FROM @T
END

EXECUTE [dbo].[usp_RandomNumber] 8,10