所以我有一個存儲過程,我想連接到它并在 python 中執行,這樣我就可以將數據導出為一個花哨的表。這是我使用的代碼,注釋是我嘗試過的代碼。import plotly as pyimport plotly.figure_factory as ffimport pandas as pdimport pypyodbcimport pyodbcimport datetimeimport seaborn as snsimport matplotlib.pyplot as plt#force the ODBC driver to use case-sensitive column namespypyodbc.lowercase = True startdate = '2018-10-23 08:00'enddate = '2018-10-24 12:00'params = startdate,enddate##Establishing a connection to SQL databaseconnection = pypyodbc.connect('Driver={SQL Server};' 'Server=LOLOL;' 'Database=LOL_Collection;' 'trusted_connection=yes;')crsr = connection.cursor()SQL = """SET NOCOUNT ONdeclare @start = '2018-10-23 08:00'declare @end = '2018-10-24 12:00'exec [dbo].[AM_SIGNAL_Histogram] @start, @end"""#SQL = """# #exec [dbo].[AM_SIGNAL_Histogram] @start, @end##"""#result = crsr.execute(SQL)# #print(result.fetchall())df = pd.read_sql(SQL,connection)connection.close()這是我不斷收到的錯誤:ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server 驅動程序][SQL Server]'='附近的語法不正確。")感謝您的幫助,肯尼斯
添加回答
舉報
0/150
提交
取消