随机生成字符串

最新推荐文章于 2023-11-13 14:20:09 发布

liufeng063x

最新推荐文章于 2023-11-13 14:20:09 发布

阅读量210

点赞数

分类专栏： SQL Server

本文链接：https://blog.csdn.net/liufeng063x/article/details/83556377

版权

SQL Server 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

DECLARE @RandomID varchar(32);
DECLARE @counter smallint;
DECLARE @RandomNumber float;
DECLARE @RandomNumberInt tinyint;
DECLARE @CurrentCharacter varchar(1);
DECLARE @ValidCharacters varchar(255);
SET @ValidCharacters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
DECLARE @ValidCharactersLength int;
SET @ValidCharactersLength = len(@ValidCharacters);
SET @CurrentCharacter = '';
SET @RandomNumber = 0;
SET @RandomNumberInt = 0;
SET @RandomID = '';

SET NOCOUNT ON;

SET @counter = 1;

WHILE @counter < (@Length + 1)
BEGIN

        SET @RandomNumber = Rand();
        SET @RandomNumberInt = Convert(tinyint, ((@ValidCharactersLength - 1) * @RandomNumber + 1));

        SELECT @CurrentCharacter = SUBSTRING(@ValidCharacters, @RandomNumberInt, 1);

        SET @counter = @counter + 1;

        SET @RandomID = @RandomID + @CurrentCharacter;

END
PRINT @RandomID