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


Em
Go to Top of Page

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.
Go to Top of Page

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_

Em
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -