sql server - oracle formatting ==> to_char(12.222,'000000000009') gives me output as 000000000012. How can I get same format in TSQL? -

oracle formatting ==>  

select to_char(12.222,'000000000009') dual gives me output 000000000012.

select to_char(1,'000000000009') dual gives me output 000000000001.

select to_char(12,'000000000009') dual gives me output 000000000012.

how can same format in tsql?

let me try elaborate more. want number formatted in tsql formats in oracle. say, if enter 1 oracle query appends 11 zeros before 1. if enter 12.22 oracle query appends 10 zeros before 12.(note decimals not considered) if enter 123 output 9 zeros appended before 123.

do want this?

declare @i int=12 declare @digit_number int =10 select replicate('0', @digit_number-len(cast(@i varchar(50))))+cast(@i varchar(50))