通过Python将列表字典写入SQL Server

import pyodbc

# 创建与SQL Server数据库的连接
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=server_name;DATABASE=database_name;UID=username;PWD=password')

# 创建游标
cursor = conn.cursor()

# 创建表
cursor.execute('CREATE TABLE my_table (column1 VARCHAR(50), column2 INT)')

# 列表字典
data = [
    {'column1': 'value1', 'column2': 1},
    {'column1': 'value2', 'column2': 2},
    {'column1': 'value3', 'column2': 3}
]

# 遍历列表字典，将数据插入表中
for item in data:
    cursor.execute("INSERT INTO my_table (column1, column2) VALUES (?, ?)", item['column1'], item['column2'])

# 提交更改
conn.commit()

# 关闭连接
conn.close()