MS SQL 随机数(可用于验证码)

--定义随机数变量

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