Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # on mac terminal
- # > brew install freetds@0.91
- # > brew link --overwrite --force freetds@0.91
- # > pip install pymssql
- import pymssql
- conn = pymssql.connect(server='test.server.com', user='mega', password='pass', database='db')
- cursor = conn.cursor()
- cursor.execute('select top 10 * from dbo.tab;')
- row = cursor.fetchone()
- while row:
- print (str(row[0]) + " " + str(row[1]) + " " + str(row[2]) + " " + str(row[3]) )
- row = cursor.fetchone()
Add Comment
Please, Sign In to add comment