Local

To declare a variable in T-SQL for reuse throughout a query, the syntax is simple:

DECLARE @VariableName AS datatype
SET @VariableName = value

-- OR
DECLARE @VariableName AS datatype = value

You can also use a single declare to create multiple variable in one go:

DECLARE @VariableName AS datatype
		,@VariableName2 AS datatype