Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pymssql
- conn = pymssql.connect(host='117.103.192.45', user='vtcsmartcard', password='vtcsmartcard@2', database='kiosk.MonitorDB', as_dict=True)
- cur=conn.cursor()
- cur.execute("exec SP_GetServices 214")
- row=cur.fetchone()
- print row
- None
- cur.execute("SELECT * FROM SERVICES")
- row=cur.fetchall()
- for r in row:
- print r[0]
- print row
- []
Add Comment
Please, Sign In to add comment
