how to return multiple values from stored proc?

smen · Jan 9, 2004

hiye, can stored procedure return multiple @output's?

thanks for replying...

MacKenzie Mickelsen · Jan 9, 2004

yes you can, you just have to read the values from the parpameters
collection of the Command object

MacKenzie

Guest · Jan 9, 2004

any examples

-----Original Message-----
yes you can, you just have to read the values from the parpameters
collection of the Command object

MacKenzie

.

Scott Allen · Jan 9, 2004

See:

Retrieving the Gazoutas: Understanding SQL Server Return Codes and
Output Parameters by Mr. Vaugn
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/gazoutas.asp

How get value from stored proc	2	May 11, 2008
Parameter Type/Size Property Values for VARCHAR(MAX) Stored Proc Parameter	2	Jan 25, 2011
TableAdapter returns null for stored proc returning a single value	3	Apr 8, 2008
LINQ Query : How to return a single value from a stored procedure	1	Oct 15, 2008
TableAdapter, INNER JOINs, stored procs, and problems with Update	4	Apr 16, 2008
How do i retrieve a Return Value (0 or 1) from my stored proc?	4	Dec 21, 2005
How to get a dynamic temp table into a 2003 .NET dataset	1	Jul 8, 2008
stored procedure Q...	2	Mar 24, 2005

Ask a Question