I'm wanting to call a SQL Server stored procedure using node.js with the mssql + tedious module. One of the parameters I need to pass in is of a user-defined table type. I have a UDT parameter type available in this library which takes a Buffer for the value. However, I have no idea how to format a user-defined table type.
Is there a specification out there that explains how to serialize user-defined table type data?
I think my confusion was a case of inconsistent terminology.
According to Table Valued Parameter (TVP) Values in MSDN, user-defined table types are the same as TVPs. TVPs are supported directly according to the README of node-mssql.