declare @maxcode char(3)
set @maxcode='015'
set @maxcode =@maxcode +1
select @maxcode
结果为 '16'
怎么转换为字符串'016'
------解决方案--------------------
declare @maxcode char(3)
set @maxcode='015'
set @maxcode='0'+convert(varchar,CAST(@maxcode as int)+1)
select @maxcode
------解决方案--------------------
declare @maxcode varchar(3)
set @maxcode='015'
set @maxcode =cast(cast(@maxcode as int) +1 as varchar(3))
select right('0000'+@maxcode,3)