Alter FUNCTION dbo.f_MaxBH()
RETURNS char(5)
with encryption
AS
BEGIN
RETURN(SELECT RIGHT(100001+ISNULL(RIGHT(MAX(审批单号),5),0),5) FROM shenp WITH(XLOCK,PAGLOCK))
END
GO
RETURNS char(5)
with encryption
AS
BEGIN
RETURN(SELECT RIGHT(100001+ISNULL(RIGHT(MAX(审批单号),5),0),5) FROM shenp WITH(XLOCK,PAGLOCK))
END
GO