python调用sql server存储过程_使用Python的SQL Server存储过程(pyodbc)

我有一个存储过程,代码：

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)

如何使用此过程创建原始SQL查询以创建帐户？

我正在使用烧瓶和pyodbc.