Re: Table-Valued Parameters to MS SQL Server stored procedure

On 29/12/2013 22:20, Jürgen Wenzel wrote:
> Hello,
>
> I'm adapting a Windows perl program to work with a new MS SQL Server
> database and it involves making calls to stored procedures that takes
> Table-Valued Parameters. Is this possible with DBD::ODBC or any other
> DBI? Or at all with (strawberry) perl?
>
> Would really appreciate some help -- answers and perhaps even a short
> example -- since trying to figure this out is really starting to wear on
> me.
>
> Thanks in advance!
>
> JW
>
> .
>

I don't believe you can do that with DBD::ODBC. In fact, I don't think 
you can even do that with ODBC (if you know different and can point me 
at it I'll take a look). The traditional way around this is to use 
temporary tables.

Martin
-- 
Martin J. Evans
Wetherby, UK