pyodbc call stored procedure with parameter name

To call a stored procedure from a Python application, use pyodbc package. The procedure that you call can include input parameters (IN), output parameters (OUT), and input and output parameters (INOUT).

Execute a stored procedure

import pyodbc

server = 'tcp:SQLSERVER' 
database = 'DB' 
username = 'UID' 
password = 'PWD' 
conn = pyodbc.connect('DRIVER={SQL Server Native Client 11.0};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)

cursor = conn.cursor()

# Prepare the stored procedure execution script and parameter values
storedProc = "exec USR_SP @MeetingCode = ?, @vendor = ?, @AttendeeId = ?, @ExternalId = ?"
params = ('101','CC', ref, oid)

# Execute Stored Procedure With Parameters
cursor.execute(storedProc, params)
# Call commit() method to save changes to the database
conn.commit()

Reading Data


# After executing the above stored procedure

for row in cursor:
	# print('row = %r' % (row,))
	print(row[0])

pyodbc
An open-source Python module, to access SQL Server databases.