ALTER PROCEDURE [dbo].[SIP10103]
@KOUJO_CD AS INT,
@YLMASTER AS VARCHAR(50),
@HAIGO_DT AS INT
AS
BEGINDECLARE @CNT AS INT
DECLARE @RET_NO AS INT
SET @CNT=(SELECT COUNT(*)FROM #W4)
EXEC SPDB..SIP10104 @HAIGO_DT,@CNT,@RET_NO OUTPUT
RETURN @RET_NO输出参数为 @RET_NO
调用的存储过程SIP10104 为
ALTER PROC [dbo].[SIP10104]
@HAIGO_DT INT,
@CNT INT,
@RET_NO INT OUTPUT AS
想请教一下我这么写对么,能返回输出参数的值么
@KOUJO_CD AS INT,
@YLMASTER AS VARCHAR(50),
@HAIGO_DT AS INT
AS
BEGINDECLARE @CNT AS INT
DECLARE @RET_NO AS INT
SET @CNT=(SELECT COUNT(*)FROM #W4)
EXEC SPDB..SIP10104 @HAIGO_DT,@CNT,@RET_NO OUTPUT
RETURN @RET_NO输出参数为 @RET_NO
调用的存储过程SIP10104 为
ALTER PROC [dbo].[SIP10104]
@HAIGO_DT INT,
@CNT INT,
@RET_NO INT OUTPUT AS
想请教一下我这么写对么,能返回输出参数的值么
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货