tiny sample for executing sql on mssql server from python

get_time.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-


# ==================
# requirements.txt 
# pymssql>=2.1.3
# =================


import pymssql

config = {
  'server': '127.0.0.1',
  'user': 'sa',
  'password': 'yourStrong(!)Password'
}

with pymssql.connect(**config) as conn:
  with conn.cursor() as cursor:
    cursor.execute('SELECT GETDATE()')
    row = cursor.fetchone()
    while row:
      print(row[0])
      row = cursor.fetchone()