110,534
社区成员
发帖
与我相关
我的任务
分享
declare @tempTable table(value varchar(30),number bigint)
insert into @tempTable values('TMP1111-1111-1111-1111115',null)
insert into @tempTable values('TMP1111-1111-1111-1111116',null)
insert into @tempTable values('TMP1111-1111-1111-1111117',null)
update @tempTable
set number=replace(replace(value,'TMP',''),'-','')
select top 1 number from @tempTable order by number
declare @num bigint,@result varchar(30)
select @num = select min(Convert(bigint,replace(replace(列,'-',''),'TMP',''))) from 表;
set @num=@num-1
set @temp=convert(varchar(30),@num)
set @result=substring(@temp,1,4)+'-'
set @result=@result+substring(@temp,6,4)+'-'
set @result=@result+substring(@temp,11,4)+'-'
set @result='TMP'+@result+substring(@temp,16,7)
select @result
declare @num bigint,@result varchar(30)
select @num = min(Convert(bigint,replace(replace(列,'-',''),'TMP',''))) from 表;
set @num=@num-1
set @temp=convert(varchar(30),@num)
set @result=substring(@temp,1,4)+'-'
set @result=@result+substring(@temp,6,4)+'-'
set @result=@result+substring(@temp,11,4)+'-'
set @result='TMP'+@result+substring(@temp,16,7)
select @result
create table Card
(
cardno varchar(30)
)
insert into Card values('TMP1111-1111-1111-1111114')
insert into Card values('TMP1111-1111-1111-1111115')
insert into Card values('TMP1111-1111-1111-1111116')
select min(Convert(bigint,replace(replace(cardno,'-',''),'TMP',''))) from card
1111111111111111114
select
left('TMP1111-1111-1111-1111117',18)+
replace(right('TMP1111-1111-1111-1111117',7),
right('TMP1111-1111-1111-1111117',7),convert(varchar,(cast right('TMP1111-1111-1111-1111117',7) as bigint)+1)
declare @temp varchar(30),@num bigint,@result varchar(50)
select @temp=replace('TMP1111-1111-1111-1111115','-','')
select @temp=replace(@temp,'TMP','')
select @num=convert(bigint,@temp)
set @num=@num-1
set @temp=convert(varchar(30),@num)
select @temp
set @result=substring(@temp,1,4)+'-'
set @result=@result+substring(@temp,6,4)+'-'
set @result=@result+substring(@temp,11,4)+'-'
set @result='TMP'+@result+substring(@temp,13,7)
select @result
declare @temp varchar(30),@num bigint,@result varchar(30)
select @temp=replace('TMP1111-1111-1111-1111115','-','')
select @temp=replace(@temp,'TMP','')
select @num=convert(bigint,@temp)
set @num=@num-1
set @temp=convert(varchar(30),@num)
set @result=substring(@temp,1,4)+'-'
set @result=@result+substring(@temp,6,4)+'-'
set @result=@result+substring(@temp,11,4)+'-'
set @result='TMP'+@result+substring(@temp,16,7)
select @result