Hi, see this:
DECLARE @temp VARCHAR(30)
SET @temp = 'Example'
SELECT @temp
OR
DECLARE @temp VARCHAR(30)
SET @temp = 'Example'
SELECT *
FROM Table_Name
WHERE Table_Column = @temp
OR
DECLARE @temp VARCHAR(30)
SELECT @temp = name
FROM Table_Name
WHERE Id= 1
Hope it helps! :D