Call sql server stored procedure in Python

Question

I have a stored procedure

exec dbo.update_candidate "ur", 0

where "ur",0 -is paramtrs

But if it is called in the program, it does not work:

params = list()
name1 = "ur"
voises1 = "1"
params1=(name1,voises1)
cursor.execute("{CALL update_candidate (?,?)}",params1)

Please define it does not work? Do you get an error? It just doesn't execute? Do you have an open connection to the SQL Server? — SS_DBA
– SS_DBA, Commented Jul 26, 2017 at 12:29
Can you give more details of the error and the code? are you using pyodbc? — hoaphumanoid
– hoaphumanoid, Commented Jul 28, 2017 at 9:19

Dmitry · Accepted Answer · 2017-07-28 13:50:59Z

1

In Pyton

   params2=(name1,'5')
   cursor.execute("exec dbo.update_candidate %s,%s" % params2)
   cursor.commit()

In SQLServer:

exec dbo.update_candidate "Hadjr", 2

answered Jul 28, 2017 at 13:50

Dmitry

411 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1