pymssql如何传递输出参数

Question

我试过使用以下代码：

   outputparam1 = pymssql.output(int)
   outputparam2=pymssql.output(int)
   outputparam3=pymssql.output(int)

    try:
        with pymssql.connect('localhost','sa','anypassword', 'anydb') as conn:
            with conn.cursor(as_dict=True) as cursor:
                cursor.callproc("storedprocedure_name",('inputparam', outputparam1, outputparam2, outputparam3))
    except Exception,e:
        pass

这是Server存储过程：

ALTER PROCEDURE [dbo].[storedprocedure_name]
     (@inputparam NVARCHAR(100),                                         
      @outputparam1 INT OUTPUT,
      @outputparam2 INT OUTPUT,
      @outputparam3 INT OUTPUT)
AS
BEGIN
END;

此代码仍然引发异常。

预期参数@outputparam1 1.“

任何帮助都是非常感谢的，谢谢

Answer 1

cursor.callproc('storedprocedure_name', (first_param, second_param, an_output_param,))

然后返回的值将在"an_output_param“变量中可用。

在你的情况下你应该试试这个。

cursor.callproc("storedprocedure_name", ('inputparam', outputparam1, outputparam2, outputparam3,))

也试试这个

sqlcmd = """
DECLARE @outputparam1 INT, @outputparam2 INT, @outputparam3 INT

EXEC storedprocedure_name
     %s, @outputparam1 OUT, @outputparam2 OUT, @outputparam3 OUT

SELECT @outputparam1, @outputparam2, @outputparam3
"""
res = conn.execute_row(sqlcmd, ('inputparam'))