使用pymssql写入CSV并使用列名作为标题

import pymssql
import csv

conn = pymssql.connect(server='服务器地址', user='用户名', password='密码', database='数据库名')
cursor = conn.cursor()

cursor.execute('SELECT 列名1, 列名2, 列名3 FROM 表名')
rows = cursor.fetchall()

with open('output.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow([column[0] for column in cursor.description])  # 写入列名作为标题
    writer.writerows(rows)  # 写入查询结果数据

cursor.close()
conn.close()

import pymssql
import csv

conn = pymssql.connect(server='服务器地址', user='用户名', password='密码', database='数据库名')
cursor = conn.cursor()

cursor.execute('SELECT 列名1, 列名2, 列名3 FROM 表名')
rows = cursor.fetchall()

with open('output.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow([column[0] for column in cursor.description])  # 写入列名作为标题
    writer.writerows(rows)  # 写入查询结果数据

cursor.close()
conn.close()