Must declare the scalar variable '@Jobcode'

Question

DECLARE @JOBCODE NVARCHAR(MAX);
SET @JOBCODE = (SELECT TOP 1 JOBCODE FROM EMPLOYEES WHERE EMPLOYEENAME = 'SCHIPPERT, RALF')

I am trying to declare a variable but getting error:

Must declare the scalar variable

Which dbms are you using? (The above code is product specific.) — jarlh, Mar 29 '23 at 10:01

score 0 · Answer 1 · answered Mar 29 '23 at 10:07

The error is because you're trying to assign a SELECT statement directly to a variable without using the SELECT itself for the assignment.

DECLARE @JOBCODE NVARCHAR(MAX);
SELECT TOP 1 @JOBCODE = JOBCODE FROM EMPLOYEES WHERE EMPLOYEENAME = 'SCHIPPERT, RALF';

Here you use the SELECT statement to assign the result directly to the @JOBCODE variable via using @JOBCODE = JOBCODE

1 Answers1