How to fix “Must declare the scalar variable ”@int"

Question

I'am creating a stored procedure to insert data into a table if the parameter matched.

Here's my stored procedure

    CREATE PROCEDURE [dbo].[spAutoRegistPosition]
        @Position varchar(255),
        @UserID int
    AS
    IF NOT EXISTS (SELECT * FROM dbo.UserXUserGroup WHERE UserID = @int)
    BEGIN

        -- INSERT HERE
        IF @Position = 'Manager'
            INSERT INTO dbo.UserXUserGroup(UserID, UserGroupID)  
            VALUES (@UserID, 4)

        ELSE IF @Position = 'GM'
            INSERT INTO dbo.UserXUserGroup(UserID, UserGroupID) 
            VALUES (@UserID, 3)

        ELSE IF @Position = 'Direktur'
            INSERT INTO dbo.UserXUserGroup(UserID, UserGroupID)  
            VALUES (@UserID, 3)

    END
    GO

But when I run that I got this error message

Msg 137, Level 15, State 2, Procedure spAutoRegistPosition, Line 8 [Batch Start Line 9]
Must declare the scalar variable "@int"."

I already tried to declare the variable after BEGIN and didn't work.

Ed Bangga Ed Bangga · Accepted Answer · 2019-12-09T03:20:50

You don't have a variable @INT. Seems you want to use @UserID.

    CREATE PROCEDURE [dbo].[spAutoRegistPosition]
        @Position varchar(255),
        @UserID int
    AS
    IF NOT EXISTS (SELECT * FROM dbo.UserXUserGroup WHERE UserID = @UserID)
    BEGIN
        -- INSERT HERE
        IF @Position = 'Manager'
        INSERT INTO dbo.UserXUserGroup(UserID, UserGroupID)  
        VALUES (@UserID, 4)

        ELSE IF @Position = 'GM'
        INSERT INTO dbo.UserXUserGroup(UserID, UserGroupID) 
        VALUES (@UserID, 3)

        ELSE IF @Position = 'Direktur'
        INSERT INTO dbo.UserXUserGroup(UserID, UserGroupID)  
        VALUES (@UserID, 3)

    END
    GO

How to fix “Must declare the scalar variable ”@int"

1 Answers