#Using the pymssql driver
import pymssql

#Connect to your database. 
#Replace server name, username, and password with your credentials   
#Code is dependent on AdventureWorks database
conn = pymssql.connect(server='yourserver.database.windows.net', user='yourusername@yourserver', 
	password='yourpassword', database='AdventureWorks')
cursor = conn.cursor()

#SELECT
#Execute a simple select statement. 
cursor.execute('SELECT c.CustomerID, c.CompanyName,COUNT(soh.SalesOrderID) AS OrderCount FROM SalesLT.Customer AS c LEFT OUTER JOIN SalesLT.SalesOrderHeader AS soh ON c.CustomerID = soh.CustomerID GROUP BY c.CustomerID, c.CompanyName ORDER BY OrderCount DESC;')
row = cursor.fetchone()

#Print results from select statement.
while row:
    print str(row[0]) + " " + str(row[1]) + " " + str(row[2])   
    row = cursor.fetchone()

#INSERT    
#Execute an insert statement    
cursor.execute("INSERT SalesLT.Product (Name, ProductNumber, StandardCost, ListPrice, SellStartDate) OUTPUT INSERTED.ProductID VALUES ('SQL Server Express', 'SQLEXPRESS', 0, 0, CURRENT_TIMESTAMP)")
row = cursor.fetchone()

#Print the ID of the inserted row. 
while row:
    print "Inserted Product ID : " +str(row[0])
    row = cursor.fetchone()
    
    
 

#Using the pymssql driver
import pymssql

#Connect to your database. 
#Replace server name, username, and password with your credentials   
#Code is dependent on AdventureWorks database
conn = pymssql.connect(server='yourserver.database.windows.net', user='yourusername@yourserver', 
	password='yourpassword', database='AdventureWorks')
cursor = conn.cursor()

#SELECT
#Execute a simple select statement. 
cursor.execute('SELECT TOP 10 Title, FirstName, LastName from SalesLT.Customer;')
row = cursor.fetchone()

#Print results from select statement.
while row:
    print str(row[0]) + " " + str(row[1]) + " " + str(row[2])   
    row = cursor.fetchone()

#INSERT    
#Execute an insert statement    
cursor.execute("INSERT SalesLT.Product (Name, ProductNumber, Color, StandardCost, ListPrice, SellStartDate) OUTPUT INSERTED.ProductID VALUES ('Bike', 'B1', 'Blue', 50, 120, CURRENT_TIMESTAMP)")
row = cursor.fetchone()

#Print the ID of the inserted row. 
while row:
    print "Inserted Product ID : " +str(row[0])
    row = cursor.fetchone()
    
    
 

Update sample_python_linux.py