MSSQL 依日期自動產流水序號

DECLARE @dt CHAR(6)

set @dt=CONVERT(CHAR(6),GETDATE(),12)

SELECT @dt+RIGHT(1000001+ISNULL(RIGHT(MAX(BH),6),0),6)

FROM tb WITH(XLOCK,PAGLOCK)