Advertisement
Guest User

Untitled

a guest
Jul 14th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.36 KB | None | 0 0
  1. import pymssql
  2.  
  3. # connect
  4. conn = pymssql.connect(server='tkdfel05.ptportugal-dev.local\DEV', user='sa', password='Co!IRNWD', database='DEV_DOKOS_TI')
  5.  
  6. # execute query
  7. cursor = conn.cursor()
  8. cursor.execute('SELECT * FROM DK_USERS')
  9.  
  10. # fetch query results
  11. row = cursor.fetchone()
  12. while row:
  13.     print str(row[0]) + " " + str(row[1])
  14.     row = cursor.fetchone()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement