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