SQL Server format string plus front 0 or leading 0

Lazy to find a ready-made function, it turns out that the people writing SQL Server than I am lazy, even this basic function is not!

Good, because all I want is the serial number and it will be reset every month, and the maximum ordinal will not exceed 100,000. So let's use rigth:

DECLARE @SN int

DECLARE @SNLen int

Set @SNLen = 5

Set @SN = 1

Select Right (' 0000000000 ' + cast (@SN as varchar), @SNLen)

Set @SN = 333

Select Right (' 0000000000 ' + cast (@SN as varchar), @SNLen)

Set @SN = 55555

Select Right (' 0000000000 ' + cast (@SN as varchar), @SNLen)

The code might be relevant:

declare @OfYear nvarchar (4)

declare @OfMonth nvarchar (2)

Set @OfYear = Datename (yyyy, @DateTime)

Set @OfMonth = Datename (mm, @DateTime)

Yes, right.