自增长列有关问题#17

自增长列问题#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 code
select right(100000+id,5)from tb
[解决办法]
SQL code
select IDENTITY(int,1,20) as id into b_testselect right('0000'+LTRIM(id),5) as id from b_test/*id00001*/