Python模块 pyodbc的连接与使用

为了连接公司数据库的SQL Sever,用Python的pyodbc模块即可.
具体的使用方法其实感觉和pymysql都是一个样,增删查改参考pymysql就可以了

连接

import pyodbc

DRIVER = "{SQL Server Native Client 11.0}"
SERVER = "xxx.xxx.xxx.xxx"
PORT = 14330
UID = "xxx"
PWD = "xxx"
CONN = "DRIVER=%s;SERVER=%s,%s;UID=%s;PWD=%s" % (DRIVER, SERVER