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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-23 : 09:05:38
|
| pankaj writes "I wanted to return string value from stored procedure in my moudule i have to use only stored procedure ,How to do it? regards PANKAJ P. BIDWAI" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-23 : 09:30:40
|
| you can do that using OUTPUT Parameter-------------------------------------------------------------- |
 |
|
|
Pankaj_Bidwai
Starting Member
8 Posts |
Posted - 2002-04-24 : 11:46:08
|
| Hi In SQL7 output variable can return only integer value not the string |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-24 : 11:48:49
|
| There is 2 types of parameters that can come out of a stored procedure. The first is the RETURN parameter, which is the integer one you refer to. The second is the OUTPUT parameter, which is declared at the top of the SP with all the input parameters. This can return any data type. It will definately return strings - I use it a a lot.Tim |
|
|
|
|
|
|
Returning string value from stored procedure