select ('0000'+ltrim(id),5)

------解决方案--------------------
SQL code

select right(100000+id,5)
from tb

------解决方案--------------------

SQL code

select IDENTITY(int,1,20) as id into b_test

select right('0000'+LTRIM(id),5) as id from b_test

/*
id
00001
*/