Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. import csv
  2. import pymssql
  3. import sys
  4. reload(sys)
  5. sys.setdefaultencoding('utf8')
  6. test="deneme"
  7. ids="1334"
  8. with open("Hypersanal.csv") as csvfile:
  9. readCSV = csv.reader(csvfile, delimiter=';')
  10. for row in readCSV:
  11. pass
  12.  
  13. conn = pymssql.connect(host='192.168.x.x', user="user",password='passed', database='databases')
  14. cur = conn.cursor()
  15. #cur.execute('SELECT * FROM dbo.schEBI_VM_Rapor_Konfigurasyon WHERE EnvanterNo =%d ',ids)
  16.  
  17. cur.execute('UPDATE dbo.schEBI_VM_Rapor_Konfigurasyon SET DonanimAdi= "DonanimAdi" WHERE EnvanterNo =%d '%(1334))
  18. row=cur.fetchone()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement