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)