--得到新编号的函数
Alter FUNCTION [dbo].[GetNextPayOrderNo](@Type char(2))
RETURNS char(16)
AS
BEGIN
    DECLARE @dt CHAR(8)
	Select @dt=CONVERT(CHAR(8),GETDATE(),112)
    RETURN(
        Select @Type + (@dt+RIGHT(1000001+ISNULL(RIGHT(MAX(PayOrderNo),6),0),6)) 
        FROM Shopping_Pay_Basic WITH(XLOCK,PAGLOCK)
        Where PayOrderNo like @Type + @dt+'%')
END
-- Select  dbo.GetNextPayOrderNo('TT')   

执行函数获得流水号：

Select dbo.GetNextPayOrderNo('AA')