--定义随机数变量
DECLARE @randNumber varchar(10)
--定义循环变量
DECLARE @counter smallint
SET @randNumber = ''
SET @counter = 0
--设置字母
DECLARE @letter varchar(26)
SET @letter = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
--循环产生随机数组合
WHILE @counter < 5
BEGIN
DECLARE @i int
--取随机数为整数
SET @i = CONVERT(int, SUBSTRING(CONVERT(varchar(10),RAND()*10),0,2))
--随机数模2为0取数字,否则取字母
IF @i % 2 = 0
SET @randNumber = @randNumber + CONVERT(varchar(1), @i)
ELSE
SET @randNumber = @randNumber + SUBSTRING(@letter, @i, 1)
SET @counter = @counter + 1
END
SELECT @randNumber