SQL流水号

create function f_getid()
returns varchar(13)
as
begin
    declare @id varchar(13),@dt varchar(8)
    select @dt=convert(varchar,getdate(),112)
    select @id='WT'+@dt+ RIGHT(1001+ISNULL(RIGHT(max(CE01),3),0),3)
    from TBase_428 where CE01 like @dt+'%'
    return(@id)
end
go

create TABLE TBase_428    
(

RowID  int IDENTITY (1, 1) PRIMARY KEY not null,

CE01 varchar(250) default dbo.f_getid()   

)