sql-ASCII函数运用

declare @a int = ASCII('A')
declare @b int = ASCII('F')
declare @c int = 1

while(@a <= @b)
begin
	print CHAR(@a)
	
	set @a = @a + 1
	
	if(@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

 

posted @ 2014-11-14 13:28  我要找到我的全世界  阅读(1441)  评论(0)    收藏  举报