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 |
|
fraglerock
Starting Member
2 Posts |
 Posted - 2008-02-19 : 12:50:01
|
| Hello folks,First I would like to apologize if this has been asked before, but you see I am in a bit of a hurry and haven't much time to read.I need to get the @return_value of a stored procedure as part of a recordset. A custom data access layer prevents me from simply obtaining the @return_value using the regular methods.A bit of background:I have a static classDB{ public member DB.SQL //SQL Command public method DB.Execute() //Executes SQL command, returns recordset}This class demonstrates the confines in which I must code. You see I only have a string of pure sql with which to obtain the @return_value of a stored proc I cannot modify. It's not right or correct, but this is the situation I find myself in.Help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-20 : 00:04:35
|
| Did you try using OUTPUT parameters in stored procedure to retrieve the values you want?[url]http://www.sqlservercentral.com/articles/Stored+Procedures/outputparameters/1200/[/url][url]http://www.devx.com/tips/Tip/13399[/url] |
 |
|
|
fraglerock
Starting Member
2 Posts |
Posted - 2008-02-20 : 09:07:35
|
| Thanks for the response.I gave up after about an hour of research...it's not my problem anymore, but thanks for the response anyway :D |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
get @return_value from stored proc using only SQL