Table valued parameter

TVP

SQL Server : Implementation of Table Valued Parameter (TVP)

Some time there will be situation in application , where a
grid is populated with data and user has option to edit...

SQL Server 2008 T-SQL Enhancements Part - II

Continuing with his series on changes in SQL Server 2008, Arshad Ali takes a look at table enhancements and new data types.

SQL Server 2008: Table Valued Parameters

In SQL Server 2005 and earlier, it is not possible to pass a table variable as a parameter to a stored procedure. When multiple rows of data to SQL Server need to send multiple rows of data to SQL Server, developers either had to send one row at a time or come up with other workarounds to meet requirements. While a VB.Net developer recently informed me that there is a SQLBulkCopy object available in .Net to send multiple rows of data to SQL Server at once, the data still can not be passed to a stored proc.

Table-valued parameters – SQL Server 2008

In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. This article illustrates the function and usage of table-valued parameters.

Why Read-only Table Parameters is Not Enough

In this article I discuss a new feature in SQL 2008, table-valued parameters and particularly the restriction that they have to be read-only. I argue that this makes this feature considerably less useful that it could be, and that in order to build scalable applications be able to pass read-write table parameters between stored procedures is essential.

SQL Server 2008 - Table Valued Parameters

In this screencast, we look at Table Valued Parameters from both the server side and client side perspectives.

Critical Problem

i have a problem, my problem is iam making one report which will be showing the data of of activities now the data of activity report can be seen by the person who is making it and the superior above him now there is one table called "RMCPL_EMP_MASTER " which has all the details of […]

RE: Upgrade to Win 2003 32 gig Memory

nice box setup . . . extended memory is for the buffer cache only.  so, working within the normal 4gb virtual address space, there are two options only one of which is viable.  the unacceptable one would be to take 1gb from upper memory using the /3gb switch in the boot.ini file.  however, win 2k and 2k03 have a […]