Top "Table-valued-parameters" questions

Table-Valued Parameters is a feature introduced in SQL SERVER 2008.

How to pass table value parameters to stored procedure from .net code

I have a SQL Server 2005 database. In a few procedures I have table parameters that I pass to a stored …

c# sql-server stored-procedures sqlcommand table-valued-parameters
Entity Framework Stored Procedure Table Value Parameter

I'm trying to call a stored procedure that accepts a table value parameter. I know that this isn't directly supported …

c# entity-framework stored-procedures ef-code-first table-valued-parameters
Conversion of the nvarchar value '3001822585' overflowed an int column

I use following to import Excel file to SQL Server. The Excel file has all the values as string. I …

sql sql-update type-conversion table-valued-parameters
Performance of bcp/BULK INSERT vs. Table-Valued Parameters

I'm about to have to rewrite some rather old code using SQL Server's BULK INSERT command because the schema has …

performance sql-server-2008 bulkinsert table-valued-parameters
How to ALTER the Table Value Parameter

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

sql-server tsql table-valued-parameters
TVP does not conform to table type

Below is the function that inserts my data. using (SqlCommand insSwipeDataCommand = connection.CreateCommand()) { insSwipeDataCommand.Transaction = transaction; insSwipeDataCommand.CommandType = CommandType.StoredProcedure; …

sql-server tsql table-valued-parameters
How can I insert 10 million records in the shortest time possible?

I have a file (which has 10 million records) like below: line1 line2 line3 line4 ....... ...... 10 million lines So basically I want …

c# sql-server import bulkinsert table-valued-parameters
Binding empty list or null value to table valued parameter on a stored procedure (.NET)

I have created a stored procedure that takes a table valued parameter that is a table with a single column …

.net sql-server-2008 stored-procedures table-valued-parameters
Performance of User-Defined Table Types in SQL Server

We have been using User-Defined Table Types to pass a list of integers to our stored procedures. We then use …

sql-server tsql sql-server-2008-r2 user-defined-types table-valued-parameters
Is it possible to use `SqlDbType.Structured` to pass Table-Valued Parameters in NHibernate?

I want to pass a collection of ids to a stored procedure that will be mapped using NHibernate. This technique …

sql-server nhibernate table-valued-parameters