Python连接SQL Server数据库

一、安装环境

服务器：Windows Server 2016

Python版本：Python 3.8.5

服务器本地安装有SQL Server 2008 R2

二、在python中安装pymssql

D:PythonPython38>pip install pymssql
Collecting pymssql
  Downloading pymssql-2.1.5-cp38-cp38-win_amd64.whl (423 kB)
     |████████████████████████████████| 423 kB 547 kB/s
Installing collected packages: pymssql
Successfully installed pymssql-2.1.5