python调用存储过程怎么传多个参数_如何从Python中的存储过程获取输出参数？

2016 update (callproc support in pymssql 2.x)

pymssql v2.x offers limited support for callproc. It supports OUTPUT parameters using the pymssql.output() parameter syntax. Note, however, that OUTPUT parameters can only be retrieved with callproc if the stored procedure does not also return a result set. That issue is discussed on GitHub here.

For stored procedures that do not return a result set

Given the T-SQL stored procedure

CREATE PROCEDURE [dbo].[myDoubler]

@in int = 0,

@out int OUTPUT

AS

BEGIN

SET NOCOUNT ON;

SELECT @out = @in * 2;

END

the Python code

import pymssql

conn = pymssql.connect(

host=r'localhost:49242',

database='myDb',

autocommit=True

)

crsr = conn.cursor()

sql = "dbo.myDoubler"