How can we help you today? How can we help you today?

Comment problem

This code: 
ALTER PROCEDURE [dbo].[tr_obnzal_polnenje_cen]
@TipZapisa varchar(3) = 'SYS',	--comments
@nMaxLev tinyint = 0,
@nLev tinyint = 0,
@JobID varchar(10)
AS
SET NOCOUNT ON .....

Lay out SQL change to: 
ALTER PROCEDURE [dbo].[tr_obnzal_polnenje_cen]
    @TipZapisa varchar(3) = 'SYS',  --comments
    @nMaxLev tinyint = 0,
    @nLev tinyint = 0,
    @JobID varchar(10)
AS 
    SET NOCOUNT ON ......

When executing code I get Error: Must declare the variable '@nMaxLev'. If I remove the comment '--comments', works fine!?!?!

Uros
Urosd
0

Comments

1 comment

Sort by
  • Andras B
    Urosd wrote:
    This code: 
    ALTER PROCEDURE [dbo].[tr_obnzal_polnenje_cen]
@TipZapisa varchar(3) = 'SYS',	--comments
@nMaxLev tinyint = 0,
@nLev tinyint = 0,
@JobID varchar(10)
AS
SET NOCOUNT ON .....

    Lay out SQL change to: 
    ALTER PROCEDURE [dbo].[tr_obnzal_polnenje_cen]
    @TipZapisa varchar(3) = 'SYS',  --comments
    @nMaxLev tinyint = 0,
    @nLev tinyint = 0,
    @JobID varchar(10)
AS 
    SET NOCOUNT ON ......

    When executing code I get Error: Must declare the variable '@nMaxLev'. If I remove the comment '--comments', works fine!?!?!

    Uros
    Thank you, we will have a look at this issue.

    Regards,
    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.