使用Python连sqlserver分发EXCEL数据：

# coding=gbk
import pymssql #引入pymssql模块
import pandas as pd


connect = pymssql.connect('.', 'sa', '123', 'PhDb') #服务器名,账户,密码,数据库名
print("连接成功!")
df=pd.read_sql('select * from BUY_CAR', connect)
for index,row in df.iterrows():
    print(row['UPDATE_USER'])
    sql="select * from [ORDER] where UPDATE_USER='"+row['UPDATE_USER']+"'";
    df2=pd.read_sql(sql,connect)
    print(df2.size)
    if df2.shape[0]>0:
        df2.to_excel('d:/'+row['UPDATE_USER']+'.xlsx')
connect.close()