how can I use stored procedure with parameters in python code

Question

I want to use stored procedure in python code like below.

import pyodbc
conn = pyodbc.connect('Trusted_Connection=yes', driver = '{SQL Server}',
                      server = 'ZAMAN\SQLEXPRESS', database = 'foy3') 

def InsertUser(studentID,name,surname,birth,address,telephone):
    cursor = conn.cursor()
    cursor.execute("exec InserttoDB studentID,name,surname,birth,address,telephone")
    rows = cursor.fetchall()

I have a problem below part of code. How can I send function parametters to DB with InserttoDB (stored procedure)

cursor.execute("exec InserttoDB studentID,name,surname,birth,address,telephone")

ronak · Accepted Answer · 2013-04-12 05:02:41Z

2

I am not sure what database you are using but I think this should do the job.

cursor.execute("call SP_YOUR_SP_NAME(params)")

answered Apr 12, 2013 at 5:02

ronak

1,7883 gold badges20 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

how can I use stored procedure with parameters in python code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related