Sep-26-2022, 07:22 PM
Hi Team,
How to call below working stored procedure via python.
below stored procedure works in microsoft sql. when run manually.
EXEC dbo.unique_query @dbname= 'Database_India",@tablename = "States"
I have created cursor object, and attempted below code. no luck. plz assist.
How to call below working stored procedure via python.
below stored procedure works in microsoft sql. when run manually.
EXEC dbo.unique_query @dbname= 'Database_India",@tablename = "States"
I have created cursor object, and attempted below code. no luck. plz assist.
params = ('ABC_Company','Employee") sql = "Exec dbo.unique_query @dbname=?,@tablename=?" #sql = "Exec unique_query @dbname=?,@tablename=?" data = cursor.execute(sql,params) cursor.commit() print(data)