Buffer format for user-defined table types

Question

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?

Jacob · Accepted Answer · 2015-03-26 18:24:00Z

1

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.

answered Mar 26, 2015 at 18:24

Jacob

79k24 gold badges159 silver badges245 bronze badges

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

Collectives™ on Stack Overflow

Buffer format for user-defined table types

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related