I have a python script that loads , transform and calculates data. In sql-server there's a stored procedure that requires a table valued parameter, 2 required parameters and 2 optional parameters. ...

I have a table-valued parameter in SQL Server 2012 defined as: CREATE TYPE [dbo].[TVP] AS TABLE ( [Id] [int] NOT NULL, [FieldName] [nvarchar](100) NOT NULL, [Value] [sql_variant] NOT NULL ) I...

I have a SQL Server 2005 database. In a few procedures I have table parameters that I pass to a stored proc as an nvarchar (separated by commas) and internally divide into single values. I add it t...

I have created a stored procedure that takes a table valued parameter that is a table with a single column of type int. The idea is to simply pass a list of ids into the store procedure and allow t...

I'm using SQL Server 2008. How can I pass Table Valued parameter to a Stored procedure across different Databases, but same server? Should I create the same table type in both databases? Pleas...

In postgresql- what is the equivalent of stored procedure with table valued paramater(MSSQL)?

I have a user-defined function in SQL Server that accepts a TVP (table valued parameter) as parameter. In EF, how do I call such a function from C# ? I tried using the method ObjectContext.CreateQu...

I am not getting option like 'ALTER TO' when am right clicking on TVP

Firstly, I understand the role of Primary Keys on tables in SQL, or any database for that matter. However, when it comes to user-defined table types, I find myself unable to see why I should creat...

I'd like to pass a two-column table-valued parameter (TVP) to an ISQLQuery: var sql = @" INSERT INTO MovieRatings (PersonID, MovieID, Score) SELECT :personID, o.movieID, o.score FROM ...

I want to pass a collection of ids to a stored procedure that will be mapped using NHibernate. This technique was introduced in Sql Server 2008 ( more info here => Table-Valued Parameters ). I just...

[Updated problem description] We have a bulk import process for which we were passing IEnumerable<SqlDataRecord> as a Table Valued Parameter (TVP) to a Stored Proc, as DataTable Type was not ...

I have a file (which has 10 million records) like below: line1 line2 line3 line4 ....... ...... 10 million lines So basically I want to insert 10 million records into the database. so I r...

I'm trying to call a stored procedure that accepts a table value parameter. I know that this isn't directly supported in Entity Framework yet but from what I understand you can do it using the Exec...

I am using .NET Core and Dapper. My problem is that .NET Core doesn't have DataTables, and that's what Dapper uses for table-valued parameters (TVP). I was trying to convert a List<T> to a Li...

I'm having SQL performance issues on Azure with complex EF6 queries. The environment is configured as an elastic pool. In the development area, the eDTU limit is hit frequently via CPU usage which ...

What's the point of DataTable.AsTableValuedParameter method which returns a SqlMapper.ICustomQueryParameter when having to pass a datatable as TVP to DB using Dapper? I could send TVPs to DB just ...

When implementing table-valued parameters, one of the most common ways to generate an IEnumerable<SqlDataRecord> for use by the parameter is code like this (e.g., https://mcmap.net/q/41637/-h...

Is there a way of using Table-Valued Parameter with Hibernate ? https://learn.microsoft.com/en-us/sql/connect/jdbc/using-table-valued-parameters#passing-a-table-valued-parameter-as-a-resultset-ob...

While trying to pass a table in as a parameter to a stored procedure via Dapper, I came across this SO answer, which indicates that it is directly supported in Dapper. In .NET core however, DataTab...

Is it possible, and if so how, to pass data to a table-valued parameter of a stored function using SQL EXEC? I know how to pass in data from C#. One of my four stored procs using table-valued par...

I want to pass a collection of IDs (via table-valued parameter) to an NHibernate IQuery select statement to be used in a join: In native SQL, I can do this (SQLSelectData below). Notice there is no...

I have a problem of inserting huge amount of data to SQL server. Previously I was using Entity framework, but it was damn slow for just 100K root level records ( containing separately two distinct...

I'm using SQL Server 2008 R2 and I've created a TVP that I want to use as a parameter to a stored proc but I get a message saying that it can't be found or I don't have permission. I can use the T...

I need to know if i need to add a sort-column to my custom table-type which i could then use to sort or if i can trust that the order of parameters remains the same even without such a column. Thi...