1. Install the pymssql package.
pip install pymssql
2. Create the your .py file.
test_mssql.py
import pymssql
conn = pymssql.connect(host='<host>', user='<username>', password='<password>', database='<dbname>')
cur = conn.cursor()
cur.execute('SELECT CONVERT(date, CURRENT_TIMESTAMP)')
row = cur.fetchone()
while row:
print "CURRENT_TIMESTAMP=%s" % (row[0])
row = cur.fetchone()
conn.close()
Continue reading Python – Connect to MSSQL server using pymssql package