By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
declare @TEMP table (ID int, Name varchar(max));
insert into @temp SELECT 1 AS ID, 'a' Name;
SELECT * FROM @TEMP
WHERE @TEMP.ID = 1 ;
Msg 137 Level 16 State 1 Line 5
Must declare the scalar variable "@TEMP".
declare @TEMP table (ID int, Name varchar(max));
insert into @temp SELECT 1 AS ID, 'a' Name;
SELECT * FROM @TEMP
WHERE "@TEMP".ID = 1 ;
| ID | Name |
|---|---|
| 1 | a |