自增长列有关问题#17_Sql Server

自增长列问题#17
select IDENTITY(int,1,1) as id into bb_test

这个增加进去了

但是我要的是 0000+ID AS ID1

然后截取5位 right（ID1,5)

求一个语句完成#123

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

SQL code

select ('0000'+ltrim(id),5)
------解决方案--------------------
SQL codeselect right(100000+id,5)from tb
------解决方案--------------------
SQL codeselect IDENTITY(int,1,20) as id into b_testselect right('0000'+LTRIM(id),5) as id from b_test/*id00001*/