/*
功能:将一个整型数字转换成带前导零的固定长度数字字符串
*/
ALTER FUNCTION [dbo].[fnGenerateFixLengthCode]
(@code as int
,@codeLength as int)
RETURNS
varchar(100)
AS
BEGIN
declare @returnCode as varchar(100)
set @returnCode=convert(varchar(100),@code)
set @returnCode=isnull(replicate('0',@codeLength-len(@returnCode)),'')+@returnCode
return @returnCode
END
Sql将一个整型数字转换成带前导零的固定长度数字字符串
最新推荐文章于 2024-05-06 21:39:37 发布