MSSQL table valued expressions & custom types

[pawhan11]

Hello,

I use stored procedures a lot in LV to interact with database. 

Now I need to pass large data set into stored procedure, 

https://docs.microsoft.com/en-us/sql/relational-databases/tables/use-table-valued-parameters-databas...

this seems like the best option. How can pass custom types using NI DB connectivity toolkit? I can choose only basic types like string or numeric

[EcthelionV]

Do you have an example of the query you want to build????

[pawhan11]

Sory for late response

For example:

DECLARE @myVar AS TestType;
INSERT INTO @myVar
VALUES
(1,'233333332'),
(2,'asd');

EXEC MultipleInsert @myVar

I can do this directly from SSMS and executes fine.

When I try to pass custom data type to stored procedure using LV I always get error about invalid argument data types. 

[mikeporter]

Two points:

First, how large is large? Are we talking a couple hundred bytes or a couple million?

Second, the problem is the DBCT. It is large and cumbersome, and as you are finding, unnecessarily restrictive.

Better to use ADO to talk directly to the DBMS.

Mike...

[pawhan11]

Thanks for reply.

We are talking about ~5k rows to insert and inserting row by row using SP will take too long.

I can use ado directly but problem will remain the same - how to pass my custom structure into parameter correctly and how to get size correctly

[pawhan11]

I have tried multiple other options and still can not get it right for custom types.

I have tried from C# and works without problems.

[_EMG_]

Hi,

sorry for putting up this older thread, but did you finally get it running using LabVIEW and TVP's?

Thanks for an answer!