pip install pymssql
python
import pymssql
conn = pymssql.connect(server='hostname', user='username', password='password', database='dbname')
cursor = conn.cursor()
cursor.execute('SELECT * FROM tablename')
result = cursor.fetchall()
for row in result:
print(row)
cursor.close()
conn.close()