Share via

Does the SQL Server connector action execute stored procedure support tvp's?

Mike Lee 247 Reputation points
2022-12-14T13:46:53.01+00:00

Hello,

I'm looking to use the Execute Stored Procedure action to insert records into a table in bulk (e.g. 100 rows at a time). I plan on creating a stored procedure that uses a TVP in order to bring in the 100 records from the caller.

Does the Execute Stored Procedure support TVP params?

Thanks,

Mike

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,489 questions
0 comments
Accepted answer
  1. Stefano Demiliani 166 Reputation points MVP
    2022-12-15T14:24:05.013+00:00

    If I remember correctly, there is no direct support for Table Value Parameters in Logic Apps now.

    Maybe you can bypass this by passing Xml or JSON to the Stored Procedure and then using SQL Server native Xml/JSON support to treat them as tables.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.