sql整数转换成定长字符串,如果结果不足所指定的长度,就在前面补“0”
DECLARE @num INT
DECLARE @length INT
SET @num=123
SET @length = 10
select REPLICATE('0',@length-DATALENGTH(CONVERT(VARCHAR,@num)))+CONVERT(VARCHAR,@num)
DECLARE @length INT
SET @num=123
SET @length = 10
select REPLICATE('0',@length-DATALENGTH(CONVERT(VARCHAR,@num)))+CONVERT(VARCHAR,@num)
posted on 2011-10-31 01:01 AngelLee2009 阅读(3628) 评论(0) 编辑 收藏 举报