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)
Talking about the database here in general, the amount of rows in the
Table-Valued Parameters (TVPs) varies between a few to a few hundred,
maybe up to a thousand. If I had to guess, I'd say that TVPs are mostly
used for smaller amounts, though.
Currently (MS SQL 2008 and 2012), TVPs must be
It appears as if Microsoft SQL Server Native Client 10 and 11 have
support for this in their ODBC implementation. At least according to
http://technet.microsoft.com/en-us/library/bb522663(v=sql.105).aspx
http://technet.microsoft.com/en-us/library/bb522663%28v=sql.105%29.aspx The
second half of
On 2013.12.30 5:23 AM, Jürgen Wenzel wrote:
Using temporary tables, or any other database workaround, isn't an option for
me, so unless there's a way to use TVPs with stored procedures I'll probably
have to abandon Perl (which, except for being extremely sad for me and very
satisfying for the
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 --
Something I'm wondering, in the general case, are the table values being passed
on these parameters large or small? For example, is it a list of line items for
an invoice (small) or could it say be millions of records in one call? I say
this regardless of whether these values are being passed