DECLARE @n INT,@l INT SET @n=123 SET @l=5 SELECT CASE WHEN LEN(@n)>=@l THEN RTRIM(@n) ELSE REPLICATE('0',@l-LEN(@n))+RTRIM(@n) END
declare @a int select @a=123select right(100000+@a,5)
或者DECLARE @n INT,@l INT SET @n=123 SET @l=5 SELECT RIGHT(REPLICATE('0',100)+RTRIM(@n),@l)
-- Declare @t Int,@Len Int Set @t=123 Set @Len=5 Select Right(Power(10,@Len+1)+@t,@Len)
DECLARE @Number int DELCARE @strNumber varchar(50); DECLARE @CommentNumber varchar(50);set @strNumber=Convert(varchar(50),@Number);IF(len(@strNumber<5) BEGIN SET @CommentNumber ="0"+@strNumber END
夜兄的代码都出了,你们还敢发其它的吗?declare @a int select @a=123 select right(100000+@a,5)--高明。
SET @n=123
SET @l=5
SELECT CASE WHEN LEN(@n)>=@l THEN RTRIM(@n) ELSE REPLICATE('0',@l-LEN(@n))+RTRIM(@n) END
select @a=123select right(100000+@a,5)
SET @n=123
SET @l=5
SELECT RIGHT(REPLICATE('0',100)+RTRIM(@n),@l)
Declare @t Int,@Len Int
Set @t=123
Set @Len=5
Select Right(Power(10,@Len+1)+@t,@Len)
DELCARE @strNumber varchar(50);
DECLARE @CommentNumber varchar(50);set @strNumber=Convert(varchar(50),@Number);IF(len(@strNumber<5)
BEGIN
SET @CommentNumber ="0"+@strNumber
END
select @a=123
select right(100000+@a,5)--高明。