Call stored procedure with table parameter

Is it possible to call a stored procedure with a Table parameter?

I see that the System.Data.SqlDbType enumeration contains a value called
Structured, and the description in help says "A special data type for
specifying struyctured data contained in table-valued parameters". But, I
haven't figured out how to use this.

Table-Value Parameters are new in SQL Server 2008
http://dotnethitman.spaces.live.com/blog/cns!E149A8B1E1C25B14!129.entry


--
Misbah Arefin
https://mcp.support.microsoft.com/profile/MISBAH.AREFIN
http://www.linkedin.com/in/misbaharefin


"Jeremy" wrote:

> Is it possible to call a stored procedure with a Table parameter?
>
> I see that the System.Data.SqlDbType enumeration contains a value called
> Structured, and the description in help says "A special data type for
> specifying struyctured data contained in table-valued parameters". But, I
> haven't figured out how to use this.
>
>
>

Table-valued parameters are being introduced in SQL Server 2008, so if
you're using an earlier version, the Structured enumeration isn't
going to do anything interesting. Bob Beauchemin's blog has a short
explanation
http://www.sqlskills.com/blogs/bobb...Server2008.aspx
and here's the link to SQL BOL for the documentation:
http://msdn.microsoft.com/en-us/library/bb510489(SQL.100).aspx.

--Mary

On Tue, 6 May 2008 11:34:06 -0700, "Jeremy" <nospam@please.com> wrote:

>Is it possible to call a stored procedure with a Table parameter?
>
>I see that the System.Data.SqlDbType enumeration contains a value called
>Structured, and the description in help says "A special data type for
>specifying struyctured data contained in table-valued parameters". But, I
>haven't figured out how to use this.
>