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()

浙公網安備 33010602011771號