I'm writing essentially my first real Stored Procedure, and I continue to get this error when I execute it, regarding an @return_value, which I have not even declared in the Stored Procedure. It displays this code that I did not write:
DECLARE @return_value int
EXEC @return_value = [dbo].[PRax3]
SELECT 'Return Value' = @return_value
And gives this error message, which is very cryptic:
Msg 102, Level 15, State 1, Procedure ResultingNewQuery, Line 1
Incorrect syntax near ')'.
(1 row(s) affected)
I have no idea what it is talking about and would appreciate any help. Is it just me or is SQL Server really not intuitive at all? Thanks a lot in advance.