Sql-server – Classic ADO and Table-Valued Parameters in Stored Procedure

adosql serverstored-proceduresvb6

Is there some way to pass a table-valued parameter to a stored procedure in SQL Server via classic ADO?

Best Answer

Classic ADO is COM and OLE and the SQL Native Client supports Table Valued Parameters over OleDB, see Table-Valued Parameters (OLE DB). One would have to get its hand dirty and code straight to the OleDB interfaces (in C/C++).

Also TVPs are only in SQL 2008, so you won't be able to use them in SQL 2005.

BTW, for completness here is the Table Valued Parameters (ODBC) reference, for the ODBC nostalgics out there...

Related Solutions

Sql-server – Check if table exists in SQL Server

For queries like this it is always best to use an INFORMATION_SCHEMA view. These views are (mostly) standard across many different databases and rarely change from version to version.

To check if a table exists use:

IF (EXISTS (SELECT * 
                 FROM INFORMATION_SCHEMA.TABLES 
                 WHERE TABLE_SCHEMA = 'TheSchema' 
                 AND  TABLE_NAME = 'TheTable'))
BEGIN
    --Do Stuff
END

Sql-server – Select columns from result set of stored procedure

Can you split up the query? Insert the stored proc results into a table variable or a temp table. Then, select the 2 columns from the table variable.

Declare @tablevar table(col1 col1Type,..
insert into @tablevar(col1,..) exec MyStoredProc 'param1', 'param2'

SELECT col1, col2 FROM @tablevar

Best Answer

Related Solutions

Sql-server – Check if table exists in SQL Server

Sql-server – Select columns from result set of stored procedure

Related Topic