sql server2008 FUNCTION中设置默认值, ORACLE FUNCTION原文:
CREATE OR REPLACE FUNCTION F_GET_TRACE_BAR(inCNTR_CD IN T_SHIP_ORDER_LINE.CNTR_CD%TYPE
,inCARR_CD1 IN M_CARRIER.CARR_CD1%TYPE
,inTRACE_NUM IN T_FARE_DTL.CARRIER_TRACE_NUM%TYPE
,inPACK_NUM IN NUMBER DEFAULT NULL
) RETURN VARCHAR2
IS
.....
EXCEPTION
WHEN OTHERS THEN
RETURN NULL ;
END ;转sql 后CREATE FUNCTION [dbo].[F_GET_TRACE_BAR](@inCNTR_CD VARCHAR(100)
,@inCARR_CD1 VARCHAR(100)
,@inTRACE_NUM VARCHAR(100)
,@inPACK_NUM DECIMAL(20,5)=NULL
)RETURNS VARCHAR(4000)
AS
BEGIN
.....
END;sql server测试语句 SELECT dbo.F_GET_TRACE_BAR('001','101','1') 报错参数不足高手们帮忙看下~!
CREATE OR REPLACE FUNCTION F_GET_TRACE_BAR(inCNTR_CD IN T_SHIP_ORDER_LINE.CNTR_CD%TYPE
,inCARR_CD1 IN M_CARRIER.CARR_CD1%TYPE
,inTRACE_NUM IN T_FARE_DTL.CARRIER_TRACE_NUM%TYPE
,inPACK_NUM IN NUMBER DEFAULT NULL
) RETURN VARCHAR2
IS
.....
EXCEPTION
WHEN OTHERS THEN
RETURN NULL ;
END ;转sql 后CREATE FUNCTION [dbo].[F_GET_TRACE_BAR](@inCNTR_CD VARCHAR(100)
,@inCARR_CD1 VARCHAR(100)
,@inTRACE_NUM VARCHAR(100)
,@inPACK_NUM DECIMAL(20,5)=NULL
)RETURNS VARCHAR(4000)
AS
BEGIN
.....
END;sql server测试语句 SELECT dbo.F_GET_TRACE_BAR('001','101','1') 报错参数不足高手们帮忙看下~!
SELECT dbo.F_GET_TRACE_BAR('001','101','1',default)--此處傳的參數個數應是4個,如果是默認值,需用default