请问怎样将整型2转换成四位数的字符串型即0002?

Question

请问怎样将整型2转换成四位数的字符串型即0002,例如:
1 ->0001
12->0012
123->0123
1234->1234不好意思我没分了,帮帮我啊!

Answer 1

SELECT replace(str(1,4),' ','0')
SELECT replace(str(12,4),' ','0')
SELECT replace(str(123,4),' ','0')
SELECT replace(str(1234,4),' ','0')                                                                                                                                                                                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
0001(1 row(s) affected)                                                                                                                                                                                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
0012(1 row(s) affected)                                                                                                                                                                                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
0123(1 row(s) affected)                                                                                                                                                                                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
1234(1 row(s) affected)

Answer 2

select right(left(cast(1/10000.0 as varchar(20)),6),4)
union
select right(left(cast(12/10000.0 as varchar(20)),6),4)
union
select right(left(cast(123/10000.0 as varchar(20)),6),4)
union
select right(left(cast(1234/10000.0 as varchar(20)),6),4)
         
-------- 
0001
0012
0123
1234（所影响的行数为 4 行）

Answer 3

select right(cast(1+10000 as varchar(20)),4)
union all
select right(cast(12+10000 as varchar(20)),4)
union all
select right(cast(123+10000 as varchar(20)),4)
union all
select right(cast(1234+10000 as varchar(20)),4)
         
-------- 
0001
0012
0123
1234（所影响的行数为 4 行）