The document is archived and information here might be outdated
Returns the workstation identification number.
|This feature has changed from earlier versions of SQL Server. For more information, see Behavior Changes to Database Engine Features in SQL Server 2005.|
The following example creates a table that uses
HOST_ID() in a
DEFAULT definition to record the terminal ID of computers that insert rows into a table recording orders.
CREATE TABLE Orders (OrderID int PRIMARY KEY, CustomerID nchar(5) REFERENCES Customers(CustomerID), TerminalID char(8) NOT NULL DEFAULT HOST_ID(), OrderDate datetime NOT NULL, ShipDate datetime NULL, ShipperID int NULL REFERENCES Shippers(ShipperID)); GO