a guest Aug 20th, 2019 113 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- PredString = '99'
- conn = pymssql.connect(server="MyServer", database="MyDB", port="1433", user="****", password="******")
- dfUpdate = pd.read_sql("EXEC UpdatePredictions '" + PredString + "'", conn)
- alter procedure UpdatePredictions (@PredString varchar(max)) as
- update MyTable set PredMths = @PredString
- select 'Updated.'
- EXEC UpdatePredictions '99'
RAW Paste Data