The SQL HOST_NAME is one of the System Function, which will return the Workstation name. The syntax behind this is
HOST_NAME()
SQL HOST_NAME Example
The below code snippet will show you the SQL Server Workstation name.
SELECT HOST_NAME() AS 'Workstation Name'
OUTPUT
