Call stored procedure with table parameter

[Jeremy]

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.

 

[Misbah Arefin]

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

 

[Mary Chipman [MSFT]]

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/2007/06/23/TableValuedParametersInSQLServer2008.aspx
and here's the link to SQL BOL for the documentation:
http://msdn.microsoft.com/en-us/library/bb510489(SQL.100).aspx.

--Mary