Top "Table-valued-parameters" questions

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

Table-Valued Parameters to CLR Procedures in SQL Server 2008 - possible?

This page from SQL Server 2008 BOL, talks about CLR Stored Procedures and has a section labelled, "Table-Valued Parameters", which talks …

sql-server-2008 stored-procedures clr table-valued-parameters
DataTable with a byte[] field as parameter to a stored procedure

I've been reusing this method of using a DataTable as a parameter to a stored procedure and it's been working …

c# .net datatable table-valued-parameters
EntityFrameWork and TableValued Parameter

I'm trying to call a stored procedure from EntityFramework which uses Table-value parameter. But when I try to do function …

entity-framework stored-procedures bulkinsert table-valued-parameters
Identity column in a table-valued parameter in procedure, how to define DataTable

Is it possible to pass a parameter of type "table" with a column of type "[int] IDENTITY(1,1)" to a procedure …

sql-server-2008 ado.net table-valued-parameters
How call Table Values function from stored procedure

How to call function which returns table in stored procedure. I want to do use that returned table from function …

sql-server-2008 stored-procedures table-valued-parameters table-variable
Passing Table Valued parameter to stored procedure across different databases

I'm using SQL Server 2008. How can I pass Table Valued parameter to a Stored procedure across different Databases, but same …

sql-server stored-procedures table-valued-parameters
CLR Table-valued function with array argument

I have a SQL CLR function like this one: public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction(TableDefinition = "number int", …

sql-server user-defined-functions sqlclr table-valued-parameters
Pass table value param to stored procedure using PetaPoco

For while I am trying to call SQL Server 2008 R2 stored procedure using PetaPoco. My stored procedure accepts a table …

c#-4.0 stored-procedures sql-server-2008-r2 petapoco table-valued-parameters
Table-Valued Parameter in Stored Procedure and the Entity Framework 4.0

I have a stored procedure in SQL Server 2008 called 'GetPrices' with a Table-Valued Parameter called 'StoreIDs'. This is the type …

sql-server sql-server-2008 stored-procedures entity-framework-4 table-valued-parameters
Problems with table-value parameter performance

I don't know whether this is an issue with how I'm using them or Microsoft's implementation, but SQL 2008 table-value parameters …

.net sql-server performance sql-server-2008 table-valued-parameters