HOST_NAME() T-SQL Example

Examples  
     

The following example creates a table that uses HOST_NAME() in a DEFAULT definition to record the workstation name of computers that insert rows into a table recording orders.

CREATE TABLE Orders
  (OrderID     int        PRIMARY KEY,
   CustomerID  nchar(5)   REFERENCES Customers(CustomerID),
   Workstation nchar(30)  NOT NULL DEFAULT HOST_NAME(),
   OrderDate   datetime   NOT NULL,
   ShipDate    datetime   NULL,
   ShipperID   int        NULL REFERENCES Shippers(ShipperID));
GO