Table-Valued Parameters

Matt Phipps <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAFRb2jrQ7OY4sLSXg6LJoFsYnvr+eq47ZtoZCMHyf7_vHDh26w@mail.gmail.com>
Hi FreeTDS,

Does FreeTDS support calling procs with table-valued parameters? With
either the ODBC driver or the DB-Library API? I think this is a SQL
Server-specific feature introduced in SQL Server 2008.

This page describes how to use table-valued parameters with ODBC:
https://msdn.microsoft.com/en-us/library/bb522668(v=sql.100).aspx I didn't
find any reference to SQL_SS_TABLE or "table-valued parameter" in the
source for FreeTDS (or UnixODBC for that matter) so I assume that means
table-valued parameters aren't supported. I've never used ODBC directly
though so I might be missing something.

I'm using FreeTDS 0.91 and UnixODBC 2.2.14 (the one used in Ubuntu 12.04).

Thanks,
Matt
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.