使用pyodbc连接SQL Server并查询数据

import pyodbc
cnxn = pyodbc.connect('DSN=SQL Server Wire Protocol;SERVER=10.80.0.58;DATABASE=pubs;UID=sa;PWD=abc123***')
cursor = cnxn.cursor()

cursor.execute("select * from authors t where t.au_id = '172-32-1176'")
for row in cursor.fetchall():
    print(row)