我正在嘗試在 Python 腳本中執行 SQL 存儲過程，但遇到語法問題。我嘗試了我找到的各種示例的組合，但似乎沒有一個起作用。這是我嘗試過的：county = 100200confirmed = 123456death = 12labTestCount = 0 #Example1conn.execute('{CALL [spInsertCOVIDData](@County,@Confirmed,@Death,@LabTestCount)}', ('county', 'confirmed', 'death', 'labTestCount'))#Example2query = "EXEC [spInsertCOVIDData] (@County,@Confirmed,@Death,@LabTestCount)", (county, confirmed, death, labTestCount)conn.execute(query)#Example3query = "EXEC [spInsertCOVIDData] @County=?, @Confirmed=?, @Death=?, @LabTestCount=?",(county, confirmed, death, labTestCount)conn.execute(query)#Example4query = "EXEC [spInsertCOVIDData] @County='county', @Confirmed='confirmed', @Death='death', @LabTestCount='labTestCount'"conn.execute(query)我從以下位置得到了各種錯誤的混合：('The SQL contains 0 parameter markers, but 4 parameters were supplied', 'HY000')或者The first argument to execute must be a string or unicode query.
在 Python 腳本中執行 SQL 存儲過程
慕無忌1623718
2023-09-12 16:34:29
