SQL Server/T-SQL/System/HOST NAME

returns the name of the workstation on which you are working. The syntax for the HOST_NAME function is as follows:

   <source lang="sql">

4> 5> 6> select HOST_NAME() 7> GO

---

J (1 rows affected)

</source>