set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo
ALTER function [dbo].[f_NextJD]()rETURNS CHAR(9)
AS
BeginDeclare @r char(9)
/*添加以下两行，并把dbo.getdate()函数修改成@CurrentDate*/Declare @CurrentDate datetimeSelect @CurrentDate = CurrentDate From V_GETDATE/*添加结束*/
Select @r = 'BJD' + Right(Year(@CurrentDate),2) + Right(10001 + MIN(SKY), 4) From ( SELECT SKY = Right(OrderNo, 6) From C_DaHuoOrder With(XLOCK, PAGLOCK) Union All Select 0) a Where Not EXISTS( Select * From C_DaHuoOrder With(XLOCK, PAGLOCK) Where OrderNo = 'BJD' + + Right(Year(@CurrentDate),2) + Right(10001 + a.SKY, 4))
Return(@r)
End
