Category : stored-procedures

I’m trying to execute a store procedure from python, but when I run it, I can not get the output form the cursor. import pyodbc import math import requests import pandas as pd cnx = pyodbc.connect(‘DRIVER={SQL Server};SERVER=xxxx;DATABASE=xxxx;UID=xxxxx;PWD=Minonja’) SQL_send_data=""" DECLARE @messageStatus nvarchar(200) SELECT @messageStatus = N’@messageStatus’ EXEC [cvm].[CVMSendSms_sp] @userId = N’PT180209.1100.628362′, @codeSms = 79, @messageStatus = ..

Read more

I have looked at many answers related to the following error when executing a SQL stored procedure with sqlAlchemy: ResourceClosedError: This result object does not return rows. It has been closed automatically. This is often due to not including SET NOCOUNT ON; at the beginning of the procedure, or numerous other causes of the procedure ..

Read more

Hope you are good and safe ! As part of my development activity in project. i need to update or insert the output table. i am trying to pass a DF as table valued parameter in store procedure. By using SP i want to achieve this.i am struggling more than 4 days but unable to ..

Read more