CDatabase调用存储过程的问题.
存储过程1:
CREATE PROCEDURE proc1 AS @fdiIndex INT
BEGIN
SELECT fdiAutoID,fdcName FROM tbMain WHERE fdiIndex > @fdiIndex
END
我怎么样得到结果.
存储过程1:
CREATE PROCEDURE proc1 AS @fdiIndex INT, @fdiReSult INT OUTPUT
BEGIN
IF(@fdiIndex > 0 )
SELECT @fdiReSult = 10
ELSE
SELECT @fdiReSult = 10
RETURN
END
我怎么样得到@fdiReSult
能否给个例子.谢谢.