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 |
|
naveentnk
Starting Member
15 Posts |
 Posted - 2009-05-06 : 01:22:23
|
| Guys,How to find out the default return value from a stored procedure. For Suppose if we created a sp without any parameters or with parameters sql server puts an extra parameter in the sp. That parameter returns an integer. This parameter tells whether the sp is run successfully or not.Can any one help me how to capture that extra parameter which is added by sql server to an sp.Thanks in advance.Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-06 : 01:43:47
|
declare @rc intexec @rc = dbo.uspMyStoredProcedureprint @rc
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Capturing the default return value of a sp