I am creating a stored procedure and all of my code seems to be right. However, I am getting the errors...incorrect syntax near 'value' and could not find my stored procedure. If anyone is willing to take a look and try to help me I would appreciate it. Please respond with a way to contact so I can provide a screenshot of what's going on.
2006-09-21 09:21:02 · 5 answers · asked by 33Sam 1 in Computers & Internet ➔ Programming & Design
I am using SQL code to create the procedure.
2006-09-21 09:36:25 · update #1
You should already have my email address. You can IM me your screenshot.
2006-09-22 09:37:40 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Send me PM and i'll send you my email.
Are you using MS SQL Server? Did you create the Stored Proc using the GUI or via SQL code?
2006-09-21 09:23:15 · answer #2 · answered by The First 3 · 0⤊ 0⤋
Can you give us the SQL statement, or a obfuscated version of it (i.e. select field1 from table where field2="value"). Also what system are you trying to create this stored proceedure on (Oracle, MSSQL, SQL Server, Access, PosgreSQL, etc.)?
2006-09-21 09:49:09 · answer #3 · answered by John J 6 · 0⤊ 0⤋
Double check the name of the stored proc you're calling. Spelling Errors can be a killer.
Are you calling this just from command line / enterprise manager; or, from an application (vb/c/etc)?
2006-09-21 09:26:58 · answer #4 · answered by clievers 4 · 0⤊ 0⤋
Do you recommend a function? function call ($parameters) { echo $parameters; $parameters++; return $parameters; } => in case you typed call(5) then "5" would be echoed and then "6"; Oh lo, i assumed you have been soliciting for a Hypertext Preprocessor function. Sorry. dismiss.
2016-12-18 14:29:41 · answer #5 · answered by ? 4 · 0⤊ 0⤋