時機律動來往間

import pyodbc
connStr = 'DRIVER={SQL Server};SERVER=(local)\LocalSQL;DATABASE=FinTech;UID=sa;PWD=xxxxxxxxxx'
conn = pyodbc.connect(connStr)

myList = ["The Holy Grail", "1975", "Terry Jones & Terry Gilliam", 91, "Graham Chapman"]

cur = conn.cursor()
cur.execute("Create table testFromPY (varB varchar(100))")
for sw in myList:
     cur.execute('insert into testFromPY values (?)', sw)

conn.commit()
conn.close()

/**** Import data with multiple columns to MS-SQL ****/
import pyodbc
connStr = 'DRIVER={SQL Server};SERVER=(local)\LocalSQL;DATABASE=FinTech;UID=sa;PWD=xxxxxxxxxx'
conn = pyodbc.connect(connStr)

dataList = [(20160808,9150.26,9116),(20160809,9155.08,9118)]

try:
    cur = conn.cursor()
    #cur.execute("CREATE TABLE closeTest (Date char(8) NULL, TestClose varchar(8) NULL, FutureClose varchar(5) NULL)")
    for ws in dataList:
        cur.execute('insert into closeTest Values (?,?,?)', ws)

    conn.commit()
finally:
    conn.close()