Python连接SQL Server执行存储过程1

import pyodbc

conn=pyodbc.connect(r'DRIVER={SQL Server Native Client 10.0};SERVER=1.1.1.1;DATABASE=test_1;UID=1;PWD=123')
cursor = conn.cursor()
cursor.execute("exec test @f1='510623198905148012'")

for row in cursor:
    print(row.F1, row.F4)

cursor.close()
conn.close()

简单的执行一个查询存储过程。带一个参数

没有参数直接写

cursor.execute("exec test")