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