1. 数字转asii码;ascii转数字
DECLARE @num INT
DECLARE @letter CHAR(1)
SET @letter='A'
SET @num=1
SELECT CHAR(@num+64)
SELECT ASCII(@letter)
运行结果:
2.固定数字位数,不够位数显示0
select REPLACE(STR(1,2),' ','0')
1. 数字转asii码;ascii转数字
DECLARE @num INT
DECLARE @letter CHAR(1)
SET @letter='A'
SET @num=1
SELECT CHAR(@num+64)
SELECT ASCII(@letter)
运行结果:
2.固定数字位数,不够位数显示0
select REPLACE(STR(1,2),' ','0')