SQL Server Transact Basic to Expert - Get the Language used in Current Session in SQL

This blog shows how to get the current language used for the session in SQL Server

Example:
SELECT  @@LANGUAGE Language

The expected result would be us_english