How to display output parameter

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

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

How to display output parameter

Author

Topic

radhe
Starting Member

6 Posts

Posted - 2008-07-11 : 08:08:24

hello friend i have supplied input parameters to my program but it is showing error.hereIt must takes i/p parameters and display o/p parameters in query analyser.
My code is:

create procedure sp_myproc
(
@a int,
@b int,
@result int output
)
as

Begin

set @result=@a+@b

End

The o/p can be shown bY:

EXEC 10 20

It is showing error please tell how to see the reuslt of @result in program

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-11 : 08:12:14

execute like this...


declare @r int
EXEC sp_myproc 10, 20,@r output
select @r

radhe
Starting Member

6 Posts

Posted - 2008-07-11 : 08:18:59

quote:
Originally posted by elancaster

execute like this...

declare @r int
EXEC sp_myproc 10, 20,@r output
select @r

Em

Thanks for you fast answer I executed Its working fine.Actually I am learning SP now.

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-11 : 08:21:11

might i also suggest then that you don't prefix your stored procedures sp_

radhe
Starting Member

6 Posts

Posted - 2008-07-11 : 08:41:55

quote:
Originally posted by elancaster

might i also suggest then that you don't prefix your stored procedures sp_

Em

Hi elancaster,

could you tell me exactly why sp will be useful and why we declare all variables here they are already in ASP.NET,C#.
Why all these O/P param and I/P param.
Suggest me any good books. If you are free.
Bye

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources