如何使用Pandas修改执行多参数sql存储过程的代码

Question

我需要提供4个参数来执行存储过程

如何简单地修改此代码以调用存储过程并传递多个参数

import pandas as pd
import pyodbc

DateFrom  = 2
DateTo = 3
param3 = NULL
param4 = NULL

query = 'EXEC Test_procedure @DateFrom = {0}'.format(my_params)  # How to modify it here to accept multiple?

conn = pyodbc.connect('DRIVER={SQL Server};server=MySrver;DATABASE=MyDatabase;Trusted_Connection=yes;')

df = pd.read_sql_query(query, conn, params= )  #??
df

Answer 1

只需使用qmarks扩展参数占位符：

query = 'EXEC Test_procedure @DateFrom = ?, @DateTo = ?, @param3 = ?, @param4 = ?'

df = pd.read_sql(query, conn, params=[DateFrom, DateTo, None, None])

df