创建"SS"+"YYYYMMDD"+"DDDD"14位顺序编号

创建"SS"+"YYYYMMDD"+"DDDD"顺序编号

-- SQL Server中创建订单编号的存储过程
CREATE    PROCEDURE  fxyjxcsysDDBH 
@BH   varchar ( 14 ) out
AS  
BEGIN     
     SELECT  
         @BH   =   ' DD ' + CONVERT ( char ( 8 ), getdate (), 112 )  +
                RIGHT ( ' 000 ' + CAST ( ISNULL ( MAX ( STUFF (编号, 1 , 10 , '' )) + 1 , 1 )  AS   VARCHAR ( 4 )), 4 )
     FROM  
        BSD 
     WHERE  
         substring (编号, 3 , 8 )  =   CONVERT ( char ( 8 ), getdate (), 112 )
END