Tạo mã voucher

DECLARE @length INT = 10
DECLARE @voucher NVARCHAR(50) = ''
DECLARE @characters NVARCHAR(36) = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'
DECLARE @i INT = 1
DECLARE @random INT
 
WHILE @i <= @length
BEGIN
    SET @random = ABS(CHECKSUM(NEWID())) % LEN(@characters) + 1
    SET @voucher = @voucher + SUBSTRING(@characters, @random, 1)
    SET @i = @i + 1
END
 
-- Output the generated voucher code
SELECT @voucher AS VoucherCode