Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pymssql
- # connect
- conn = pymssql.connect(server='tkdfel05.ptportugal-dev.local\DEV', user='sa', password='Co!IRNWD', database='DEV_DOKOS_TI')
- # execute query
- cursor = conn.cursor()
- cursor.execute('SELECT * FROM DK_USERS')
- # fetch query results
- row = cursor.fetchone()
- while row:
- print str(row[0]) + " " + str(row[1])
- row = cursor.fetchone()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement