How do I pass a list of parameters to a precedent?

Question

I want to pass N parameters of N types to a dynamic process.

How can I do it?

Example: struct = (Here the structure will be mounted with several parameters)

struct.id = 123 struct.name='Marisa' struct.data='2020-06-16' . . . Run sp_execute Project struct

How to pass? And in the past, how to identify?

Answer 1

There are some solutions, one of which is to use table-value Parameters. In the article Using Table-Valued Parameters in SQL Server and . NET, by Erland Sommarskog, you will find the complete itinerary.

In the database it is necessary to define the parameter structure, through the command CREATE TYPE. The type of data created is then used as a parameter in the procedure.

It is a very simple to use solution.