Python – Connect to MSSQL server using pymssql package

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()

 

3. Run it.

python test_mssql.py

 

4. It should return you today’s date.

CURRENT_TIMESTAMP=2014-07-11

 

Done =)

Reference: pymssql

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s