stored procedures with python pymssql

Question

I have this Stored procedure on my sql server :

[InsertRecord] @param1 varchar(10), @Param2 varchar(50),@Param3 varchar(10)=NULL, 

@Param4 datetime = NULL AS BEGIN

When I update it with the following code :

   connenction = pymssql.connect (host=host1,user=user1,password=password1,database=database1)
  curser = connection.cursor() 

  my_query="exec InsertRecord '%s','%s','%s','%s'" %(var1,var2,var3,var4)
  print my_query
  cur.execute(my_query)

I didn't get any sentax error and the stored procedure not updated on my DB

but when i run the my_query string from the sql managment studio the query ran as it should be . could someone provide what could be the problem with this code and how should i run this stored procedure with pymssql.

Andrew · Accepted Answer · 2014-09-23 21:09:33Z

3

As your fiance said - you have commitment issues!

connection.commit()

edited Sep 23, 2014 at 21:09

answered Oct 19, 2010 at 14:17

Andrew

4,62429 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

stored procedures with python pymssql

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