title: Using SQL Server stored procedures from Python (pyodbc)
body: <p>I'm have a stored procedure, code:</p>
  
  <pre><code>DECLARE @RC int 
  DECLARE @id varchar(13) 
  DECLARE @pw varchar(13) 
  DECLARE @depart varchar(32) 
  DECLARE @class varchar(12) 
  DECLARE @name varchar(12) 
  DECLARE @birthday varchar(10) 
  DECLARE @grade int 
  DECLARE @subgrade int 
  SELECT @id = 'test' 
  SELECT @pw = '12345' 
  SELECT @depart = 'none' 
  SELECT @class = 'GM' 
  SELECT @name = 'name' 
  SELECT @birthday = 'None' 
  SELECT @grade = 3 
  SELECT @subgrade = 2 
  EXEC @RC = [my_database].[dbo].[my_table] @id, @pw, @depart, @class, @name, @birthday, @grade, @subgrade 
  DECLARE @PrnLine nvarchar(4000) 
  PRINT 'Stored Procedure: my_database.dbo.my_table' 
  SELECT @PrnLine = ' Return Code = ' + CONVERT(nvarchar, @RC)
  </code></pre>
  
  <p>How i can make a raw sql query to create account using this procedure?
  I'm using flask and pyodbc.</p>