DECLARE @var VARCHAR(10) SET @var = '1020304'DECLARE @len INT SET @len = 8SELECT RIGHT(REPLICATE('0', @len)+@var, @len)/* 01020304 */
DECLARE @chars_str varchar(8) = '1020304'; DECLARE @return_str varchar(2) ; Declare @num int = 0,@index int = 1; set @chars_str ='0'+@chars_str while(@num <4) begin SET @return_str = substring(@chars_str,@index,2) print @return_str set @num= @num + 1 Set @index=@index + 2 end
Declare @Val VarChar(8000)
Select @Val='1020304'
if Left(@Val,1)!=0
Select @Val='0'+@Val
Select @Val=Replace(@Val,'0',',0')
Select Right(@Val,Len(@Val)-1)
只能先把数字转化成字符穿了
if Left(@Val,1)!=0
Select @Val='0'+@Val
SET @var = '1020304'DECLARE @len INT
SET @len = 8SELECT RIGHT(REPLICATE('0', @len)+@var, @len)/*
01020304
*/
DECLARE @return_str varchar(2) ;
Declare @num int = 0,@index int = 1;
set @chars_str ='0'+@chars_str
while(@num <4)
begin
SET @return_str = substring(@chars_str,@index,2)
print @return_str
set @num= @num + 1
Set @index=@index + 2
end