from os import getenv
import pymssql
conn = pymssql.connect(server = 'localhost', database = 'VCDB')
cursor = conn.cursor()
cursor.execute('select * from vpx_version')
row = cursor.fetchone()
while row:
print("ID=%d, Name=%s" % (row[0], row[1]))
row = cursor.fetchone()
conn.close()