python学习记录(1)--python3连接SQl Server,并读取表中数据
1、python3连接SQl Server,并读取表中数据。import pyodbcimport pandas as pd#如需账号、密码登录,则需加入相应参数UID、PWDcnxn = pyodbc.connect(DRIVER=’{SQL Server}’,SERVER=’.’,DATABASE=‘student_info26’)sc26 = pd.read_sql(“select...