Skip to content
Advertisement

SQL Server syntax correction [closed]

I am trying to create a SQL Server stored procedure but I am getting some errors.

Here are the errors:

Msg 102, Level 15, State 1, Procedure testproc8, Line 6 [Batch Start Line 60]
Incorrect syntax near ‘OUTPUT’

Msg 137, Level 15, State 1, Procedure testproc8, Line 7 [Batch Start Line 60]
Must declare the scalar variable “@y”

Thanks in advance

Advertisement

Answer

Remove Output and just select @y for your result

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement