Passing a Table Valued parameter to a stored procedure

Question

Here's an example of how to use table-valued parameters in a SQL Server 2008 stored procedure using .NET.

And here's the list of parameter types in CF9.

Q: Is it possible for ColdFusion to pass a table-valued parameter to a Microsoft SQL Server 2008 stored procedure?

Answer 1

Not sure.

If you need to pass a table of information, probably your best bet is to use the XML data type.

Code sample here.