#from os import getenv
import pymssql

#import numpy as np
#import pandas as pd

server = ("192.168.1.2")
user = ("authuser")
password = ("some$pecialPa$$word")
database = ("DatabaseName")


conn = pymssql.connect(server, user, password, database)
cursor = conn.cursor()
cursor.execute("""
SELECT TOP 100 TRY_CONVERT(DATETIME,REPLACE(([Date]+' '+[Time]),',','-')) as DateandTime,[Open],High,Low,[Close]
FROM DatabaseName.ThisData
""")

for row in cursor:
    print('row = %r' % (row,))

conn.close()