Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- import pymssql
- import sys
- reload(sys)
- sys.setdefaultencoding('utf8')
- test="deneme"
- ids="1334"
- with open("Hypersanal.csv") as csvfile:
- readCSV = csv.reader(csvfile, delimiter=';')
- for row in readCSV:
- pass
- conn = pymssql.connect(host='192.168.x.x', user="user",password='passed', database='databases')
- cur = conn.cursor()
- #cur.execute('SELECT * FROM dbo.schEBI_VM_Rapor_Konfigurasyon WHERE EnvanterNo =%d ',ids)
- cur.execute('UPDATE dbo.schEBI_VM_Rapor_Konfigurasyon SET DonanimAdi= "DonanimAdi" WHERE EnvanterNo =%d '%(1334))
- row=cur.fetchone()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement