Python向SQL Server插入数据

Question

我在想为什么这个不管用。我没有收到任何错误提示，但它就是不往表格里写数据。

import pyodbc
connprod = pyodbc.connect('DRIVER={SQL Server};SERVER=server;DATABASE=master;Trusted_Connection=yes')
cursorprod = connprod.cursor()

conndev = pyodbc.connect('DRIVER={SQL Server};SERVER=server;DATABASE=master;Trusted_Connection=yes')
cursordev = conndev.cursor()

connlocal=pyodbc.connect('DRIVER={SQL Server};SERVER=server;DATABASE=DBA;Trusted_Connection=yes')
cursorlocal = connlocal.cursor()

cursorprod.execute("SELECT Servername = @@servername    ,Date = getdate()   ,wait_type  ,waiting_tasks_count    ,wait_time_ms   ,max_wait_time_ms   ,signal_wait_time_ms FROM sys.dm_os_wait_stats GO")
rows = cursorprod.fetchall()

for row in rows:
    cursorlocal.execute('insert into dba.dbo.dm_os_wait_stats values (?,?,?,?,?,?,?)', row)
    cursorlocal.commit

Answer 1

如果你的例子是正确的，那你没有调用 commit 方法：

cursorlocal.commit()