22,210
社区成员
发帖
与我相关
我的任务
分享
create FUNCTION auto_bxdh()
RETURNS VARCHAR(20)
as
begin
declare @dh varchar(20)
set @dh=''
select @dh=max(报修单号) from 报修表
where 报修单号 like 'BX'+replace(substring(convert(varchar(20),getdate(),120),1,10),'-','')+'%'
if(@dh<>'')
set @dh=substring(@dh,1,10)+right('0'+cast(cast(right(@dh,2) as int)+1 as varchar(2)),2)
else
set @dh='BX'+replace(substring(convert(varchar(20),getdate(),120),1,10),'-','')+'01'
return @dh
end