exec dbo.p_MakeBackup 'd:\buz\trades_sql\'

import pypyodbc
#всякое разное ...
    conn = pypyodbc.connect(str_conn)
    cursor = conn.cursor()
    fpath = r"'d:\buz\trades_sql\'"
    command_text = "exec dbo.p_MakeBackup "  + fpath
    cursor.execute(command_text )

create table t_test (val int);
go
create procedure p_test_ins (@param int)
as 
begin
set nocount on;
--exec p_test_ins 7
insert into t_test (val) select @param;
end;

  
  val = 11
  command_text = "exec dbo.p_test_ins  "  + str(val)
  cursor.execute(command_text )