multiple ouput parameter - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

multiple ouput parameter

Author

Topic

hotshot_21
Yak Posting Veteran

97 Posts

Posted - 2007-08-08 : 05:49:41

is it possible to return multiple output values in stored prcodeure
for eg.
Create Proc XYZ
( @x int output,@y int output,@z int ouput)
As
Begin
SET @X= Select from table
SEt @Y=SELECT from table
set @z=slect from table
end

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2007-08-08 : 05:52:00

Yes,
Why are you asking the question, haven't you tried it yet?

Give it a try and if you still have problems post your code and ask for help.

Duane.