SqlServer创建通过表生成流水号

创建函数：

ALTER FUNCTION [dbo].[GetEventSequence]
( 
)
RETURNS char(16)
AS
BEGIN  
    DECLARE @dt CHAR(8)  
    SELECT @dt=CONVERT(CHAR(8),GETDATE(),112)  
    RETURN(  
         SELECT (CONVERT(CHAR(8),GETDATE(),112)+RIGHT(1000001+ISNULL(RIGHT(MAX(code),6),0),6))   
        FROM table_name WITH(XLOCK,PAGLOCK)
	where CONVERT(CHAR(8),create_time,112)=CONVERT(CHAR(8),GETDATE(),112))  
END

　查询数据：SELECT dbo.GetEventSequence()