First, there's garbage at the end of your sproc. Second, double click on the error message and QA will bring you to the line with error.
>Hi everybody,
>
>I'm trying to write an SP. Here is what I've wrote so far:
>
>
>
>
>DECLARE <@variable_for_output_parameter, sysname, @p2_output> <datatype_for_output_parameter, , int>
>EXECUTE <procedure_name, sysname, proc_test> <value_for_param1, , 1>, <@variable_for_output_parameter, sysname, @p2_output> OUTPUT
>SELECT <@variable_for_output_parameter, sysname, @p2_output>
>GO
>
>I when tried to execute it and here is what I got:
>=======================================================
>Server: Msg 170, Level 15, State 1, Procedure sp_InsertShoppingCartInfo, Line 58
>Line 58: Incorrect syntax near 'UserID'.
>Server: Msg 170, Level 15, State 1, Procedure sp_InsertShoppingCartInfo, Line 70
>Line 70: Incorrect syntax near 'CartID'.
>
>What is incorrect here?
--sb--