select HOST_ID() as 'Host ID' : HOST_ID « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. HOST_ID

3>
4> select HOST_ID() as 'Host ID'
5> GO
Host ID
----------
1456

(1 rows affected)