生成流水号

ALTER PROC [dbo].[SerNumCode_Make]
@Code VARCHAR(10),
@Comsite VARCHAR(10)
AS
BEGIN
DECLARE @NUm INT

SELECT @NUm = NUm FROM B_SerNumCode WHERE Code = @Code AND Comsite = @Comsite AND CYear = YEAR(GETDATE()) AND CMonth = MONTH(GETDATE())

IF @NUm IS NULL
 BEGIN
  SET @NUm = 1
  INSERT B_SerNumCode (Code,CYear,CMonth,Num,Comsite) VALUES(@Code,YEAR(GETDATE()),MONTH(GETDATE()),1,@Comsite)
 END
ELSE
 BEGIN
  SET @NUm = @NUm + 1
  UPDATE B_SerNumCode SET NUm = @NUm WHERE Code = @Code AND Comsite = @Comsite AND CYear = YEAR(GETDATE()) AND CMonth = MONTH(GETDATE())
 
 END
SELECT @NUm
END