显示26个小写字母及其对应的ASCII码值
CREATE PROCEDURE proc_sql
AS
BEGIN
DECLARE @i INT;
SET @i=0;
WHILE @i<26
BEGIN
PRINT CHAR(ASCII('a')+@I)+'的ASCII码值是'+CAST(ASCII('a')+@i AS VARCHAR(50));
SET @i=@i+1;
END
END
执行存储过程:
EXEC proc_sql;
删除存储过程:
DROP PROCEDURE proc_sql;