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 |
|
ppl1
Starting Member
5 Posts |
 Posted - 2006-05-21 : 09:59:23
|
| hi,i wrote a store procedure that gets one parameter and returns a number , something like this-ALTER PROCEDURE [dbo].[FuncName] @value floatASBEGIN SELECT 2ENDim calling to the sp with one parameter called "@value" but im getting the error-"Procedure or function FuncName has too many arguments specified."what is the problem?thanks in advanced. |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-05-21 : 10:02:24
|
| post how are you trying to call this function?If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
ppl1
Starting Member
5 Posts |
Posted - 2006-05-21 : 10:07:30
|
| im using my own class to connect to database (and its working for sure)im sending the parameter like this-("@value", SqlDbType.Float, 4, 2) |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-05-21 : 10:18:36
|
| Try to run this procedure from Query Analyser and if its running properly .. then there is some problem with your front end code you need to debug itIf Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
ppl1
Starting Member
5 Posts |
Posted - 2006-05-21 : 10:26:47
|
| ok i get thati need to use output parameterthanks |
|
|
|
|
|
|
too many arguments problem