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 - 2007-01-23 : 10:12:23
|
| John writes "Is it possible to return a decimal from a stored procedure? I have a decimal return type that is converted to an int when my stored procedure returns the value.I could do this in a function however, the afore-mentioned procedure calls the sp_executesql procedure which cannot be called in a function.I cannot believe this is a pain.Help!!!" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-23 : 10:15:06
|
you can only return an integer from a Stored Procedure. Other than that you should use OUTPUT parameter
KH |
 |
|
|
|
|
|
Stored Procdures