Can Tabled-Value-Parameters feature support dynamic struct?

[zhanghaiyang9999]

For example, there are two tables in MSSQL, one is table1,another is table2, but table1 and table2 have different fields.
see table1 has 3 fields such as ID, Name, Age, and table2 has 4 fields such as ID, Company, Position, Salary, can we dynamically create different struct to use the TVP feature? if we pre-define the struct in code for the two tables, it's ok, but if we have hundreds of tables, it's impossible to pre-define the struct for every table.

Thanks!

[NikitaDef]

For example, there are two tables in MSSQL, one is table1,another is table2, but table1 and table2 have different fields. see table1 has 3 fields such as ID, Name, Age, and table2 has 4 fields such as ID, Company, Position, Salary, can we dynamically create different struct to use the TVP feature? if we pre-define the struct in code for the two tables, it's ok, but if we have hundreds of tables, it's impossible to pre-define the struct for every table.

Thanks!

Hi, can you write some example of code. I don't understand how to want use TVP