自增长列有关问题#17

自增长列问题#17select IDENTITY(int,1,1) as id into bb_test这个增加进去了但是我要的是 0000+IDAS ID1

自增长列问题#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*/