Python – Connect to MSSQL server using pymssql package

1. Install the pymssql package.

pip install pymssql


2. Create the your .py file.

import pymssql
conn = pymssql.connect(host='<host>', user='<username>', password='<password>', database='<dbname>')
cur = conn.cursor()

row = cur.fetchone()
while row:
  print "CURRENT_TIMESTAMP=%s" % (row[0])
  row = cur.fetchone()



3. Run it.



4. It should return you today’s date.



Done =)

Reference: pymssql

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.