Posted by Erland Sommarskog on 08/16/06 21:22

Sandesh (sandesh27uk@gmail.com) writes:
> I have a scenario in which my stored procedure has to return few
> variables with their value and also the collection. Now in SQL their is
> no such as array, so the best is to return the table in place of.
>
> I am execting the stored procedure by having sql command in place.
> and created the various parameters(variables) those i need the values
> of and secondly wondering how should i be creating the parameter as a
> table returntype.

You cannot pass table variables as parameters.

I have an article on my web site that discusses a couple of ways to
skin the cat: http://www.sommarskog.se/share_data.html.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]