Cannot use the OUTPUT option when passing a constant to a stored procedure.

Hi experts,

I am tring to execute my stored procedure in sql like this:

DECLARE @RowsAffected INT
EXEC MySP 2,1,NULL,NULL,NULL,2,4,0,@RowsAffected=0 OUTPUT
SELECT @RowsAffected

But I am getting this issue "Cannot use the OUTPUT option when passing a constant to a stored procedure."

Please help.

Try the following way

DECLARE @RowsAffected as INT
SET @RowsAffected=0
EXEC MySP 2,1,NULL,NULL,NULL,2,4,0,@RowsAffected OUTPUT
SELECT @RowsAffected

Regards,
Hajan

Thanks.