ms_sql_example.py

"""
Connect to an MS SQL Server and execute a query
"""

import pyodbc

conn = pyodbc.connect('Driver={SQL Server};'
                      'Server=THINKSGIVING\SQL;'
                      'Database=AdventureWorks2017;'
                      'Trusted_Connection=yes;')

cursor = conn.cursor()
cursor.execute('SELECT TOP 100 * FROM AdventureWorks2017.Person.Person')

for row in cursor:
    print(row)