SQL ASCII函数示例

declare @a int = ASCII('A')
declare @b int = ASCII('F')
declare @c int = 1 --Flag
--将拼音转换成ASCII码(对应数字)

while(@a <= @b) --判断数字大小,开始循环
begin
print CHAR(@a) --打印

set @a = @a + 1

if(@a > @b) --当循环完A~F之间的数之后,将@a @b重新赋值,循环小写的字母
begin
if(@c = 1)
begin
set @a = ASCII('a')
set @b = ASCII('f')
set @c = @c + 1
end
else
begin
return
end
end
end

转载于:https://www.cnblogs.com/deng779256146/p/8810298.html