sql assign value to variable from function' code example

Example: Assign value to var in SQL

DECLARE @EmpIDVariable int;
SELECT @EmpIDVariable = MAX(EmployeeID)
FROM HumanResources.Employee;