使用python扫描SQL Server中的单个列以查找数据条目

pip install pyodbc

import pyodbc

server = '服务器地址'
database = '数据库名称'
username = '用户名'
password = '密码'
cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)

cursor = cnxn.cursor()

query = "SELECT 列名 FROM 表名"

cursor.execute(query)
rows = cursor.fetchall()

for row in rows:
    print(row)

import pyodbc

server = '服务器地址'
database = '数据库名称'
username = '用户名'
password = '密码'
cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)

cursor = cnxn.cursor()

query = "SELECT 列名 FROM 表名"

cursor.execute(query)
rows = cursor.fetchall()

for row in rows:
    print(row)