Python: Connect to SQL Server database and execute queries

ConnectSQLServerExecuteQueries.py

import pyodbc

connection = pyodbc.connect('DRIVER={SQL Server};SERVER=MYSQLSERVER\SERVERNAME;DATABASE=MyDatabase')
cursor = connection.cursor()

# select query example
cursor.execute("SELECT * FROM MyTable")
row = cursor.fetchone()
if row:
    print row

# insert query example
sql = "INSERT INTO MyTable(a,b) VALUES('a','b')"
cursor.execute(sql)
cnxn.commit()