Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - The problem of converting SQL Server conversion function into integer
The problem of converting SQL Server conversion function into integer
select right(replicate('0 ', 1)+convert(varchar( 10), 1),2)

Landlord, you can run it directly and have a look, and you can achieve the effect.

Convert (varchar (10), 1) Needless to say, as you know, replicate('0', 1) is the left bit of zero, and the second parameter is to control how many zeros are added.

Do you understand the rest of the landlord?