62,074
社区成员
发帖
与我相关
我的任务
分享
declare @t table(ordernumber varchar(7))
insert @t select (case when exists(select * from @t) then (select 'GH' + convert(varchar, (convert(int, isnull(substring(isnull(ordernumber, 'GH10000') , 3, len(isnull(ordernumber, 'GH10000')) - 2), 10000)) + 1)) from @t) else 'GH10000' end)
select * from @t
declare @id int
select @id=cast((select max(Id) from table) as int)
insert into table(id) value(@id+1)