sqlserver2005流水号（编号结果类似：CS2011081200001）

 CREATE function [dbo].[f_getNum](@title nvarchar(3),@date nvarchar(8))
 returns nvarchar(50)
as
begin
declare @str nvarchar(50)
declare @tempDate nvarchar(8)
declare @num nvarchar(5)
declare @temp nvarchar(50)
set @tempDate=''
set @num=''
declare @currentDate datetime
select @currentDate=max(create_date) from b
select @temp=max(num) from b where create_date=@currentDate
 if(@temp<>'')
  begin
          set @tempDate=substring(@temp,4,8)
           if @tempDate=@date
             begin
            --当天
            set @num=right('00000'+cast((cast(right(@temp,5) as int)+1) as nvarchar(20)),5)
   set @str=@title+@tempDate+@num
            end
           else
            begin
   --非当天
    set @str=@title+@date+'00001'
            end
  end
 else
  begin
    set @str=@title+@date+'00001'
  end
return @str
end