34,587
社区成员
发帖
与我相关
我的任务
分享
CREATE FUNCTION [dbo].[GET_UDC]
(
@P01_DB varchar(6),
@P02_SYSTEMCODE varchar(4),
@P03_REASONTYPE varchar(2),
@P04_KEY varchar(10)
)
--RETURNS INT
AS
BEGIN
return (select drdl01 from dbo.f0005
where drsy = rtrim(ltrim(@P02_SYSTEMCODE)) and drrt = rtrim(ltrim(@P03_REASONTYPE)) and rtrim(ltrim(drky)) = rtrim(ltrim(@P04_KEY)))
END
CREATE FUNCTION [dbo].[GET_UDC]
(
@P01_DB varchar(6),
@P02_SYSTEMCODE varchar(4),
@P03_REASONTYPE varchar(2),
@P04_KEY varchar(10)
)
RETURNS INT
AS
BEGIN
return (select drdl01 from dbo.f0005
where drsy = rtrim(ltrim(@P02_SYSTEMCODE)) and drrt = rtrim(ltrim(@P03_REASONTYPE)) and rtrim(ltrim(drky)) = rtrim(ltrim(@P04_KEY)))
END
return (select drdl01 from dbo.f0005
where drsy = rtrim(ltrim(@P02_SYSTEMCODE)) and drrt = rtrim(ltrim(@P03_REASONTYPE)) and rtrim(ltrim(drky)) = rtrim(ltrim(@P04_KEY)))
select drdl01 from dbo.f0005
where drsy = rtrim(ltrim(@P02_SYSTEMCODE)) and drrt = rtrim(ltrim(@P03_REASONTYPE)) and rtrim(ltrim(drky)) = rtrim(ltrim(@P04_KEY))