sql自动生成编码函数

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER function [dbo].[f_NextJD]()
rETURNS CHAR(9)

AS

Begin
Declare @r char(9)

/*添加以下两行，并把dbo.getdate()函数修改成@CurrentDate*/
Declare @CurrentDate datetime
Select @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