import pyodbc

con = pyodbc.connect("DRIVER={SQL Server};server=localhost;database=teste;uid=sa;pwd=TesteCon@123")

cur = con.cursor()
cur.execute("Select * from test")
for row in cur:
    print row.nome + ',' + row.email + ',' + row.id
cur.close()
con.close()

import pyodbc
# Some other example server values are
# server = 'localhostsqlexpress' # for a named instance
# server = 'myserver,port' # to specify an alternate port
server = 'tcp:myserver.database.windows.net'
database = 'mydb'
username = 'myusername'
password = 'mypassword'
cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
cursor = cnxn.cursor()

import pymssql
conn = pymssql.connect(server='yourserver.database.windows.net', user='yourusername@yourserver', password='yourpassword', database='AdventureWorks')