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
 Transact-SQL (2005)
 sql stored procedure out parameter

Author  Topic 

desikankannan
Posting Yak Master

152 Posts

Posted - 2010-11-17 : 01:22:51
Hi,
i am working with stored procedure, i wants to know how to use
out parameter, iam working with csharp proj in front end iam passing
out parameter, how to retrive it.


Desikankannan

Sachin.Nand

2937 Posts

Posted - 2010-11-17 : 01:34:16
You mean you want to know how to set the output parameter value in C# when passed from a SP?

PBUH

Go to Top of Page

chadmat
The Chadinator

1974 Posts

Posted - 2010-11-17 : 01:38:37
If the Stored Proc you are calling has an Output Parameter, you will add the Parameter to the parameters Collection of the Command, and give it a type of Output. After you execute the command, the Parameter should contain the value that was returned from the Proc.

-Chad
Go to Top of Page
   

- Advertisement -