22,210
社区成员
发帖
与我相关
我的任务
分享
declare @tb table([id] nvarchar(16))
Insert @tb
select N'0000000000000001' union all
select N'00000256' union all
select N'aaaa7' union all
select N'aaaab' union all
select N'cc'
Select substring(max(id),1,len(max(id))-1)+char(ASCII(right(max(id),1))+1) as id from @tb