Can you pass table input parameter to SQL Server from Python

Question

MS SQL Server supports passing a table as a stored-procedure parameter. Is there any way to utilize this from Python, using PyODBC or pymssql?

Dan Field · Accepted Answer · 2015-03-31 15:08:42Z

4

There may be a way to do so using a more API-ey feature, but if all else fails you could just use whatever the API exposes to send raw SQL commands to build the tables yourself and call the procedure, using a query string like the following:

DECLARE @p1 <TableTypeName>;
INSERT @p1 VALUES (<value list...>);    
EXEC usp_Procedure @p1;

answered Mar 31, 2015 at 15:08

Dan Field

21.8k6 gold badges60 silver badges74 bronze badges

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

Comments

xorsyst · Accepted Answer · 2015-04-16 15:19:30Z

0

Use IronPython. It allows direct access to the .net framework, and therefore you can build a DataTable object and pass it over.

answered Apr 16, 2015 at 15:19

xorsyst

8,2878 gold badges42 silver badges58 bronze badges

Collectives™ on Stack Overflow

Can you pass table input parameter to SQL Server from Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related