SQL存储过程生成流水号

--创建数据库

CREATE TABLE [dbo].[NumSeq] (    [Cate] [varchar] (2)  NOT NULL ,    [DateNo] [varchar] (4)  NOT NULL ,    [Seq] [int] NULL ,    [CrTime] [datetime] NOT NULL ) --建立存储过程CREATE  PROC dpPMT_SGetMaintainSeq@MaintainCate VARCHAR(2) AS--

***********************累加编号***********************************************

DECLARE @MaintainNo VARCHAR(12) IF NOT EXISTS(SELECT             *        FROM             NumSeq        WHERE             Cate=@MaintainCate AND DATEDIFF(DAY,CrTime,GETDATE())=0)    BEGIN        INSERT INTO              NumSeq(Cate,DateNo,Seq)        values(@MaintainCate,RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+REPLICATE('0',2-LEN(MONTH(GETDATE())))+CONVERT(VARCHAR(2),MONTH(GETDATE())),0)     ENDELSE    BEGIN        UPDATE             NumSeq        SET              Seq=Seq+1        WHERE             Cate=@MaintainCate AND DateNo=RIGHT(CONVERT(VARCHAR(4),YEAR(GETDATE())),2)+REPLICATE