用函数吧~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在字段的默认值上设为dbo.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在字段的默认值上设为dbo.auto_bxdh()就可以了