title: Can't insert HOST_NAME as default
body: <p>I create table as:</p>
  
  <pre><code>CREATE TABLE [UserLoginAudit] (
  UserLogginAuditId INT IDENTITY(1,1) PRIMARY KEY,
  EmpGuid UNIQUEIDENTIFIER,
  TimeLogged DATETIME,
  WorkStation VARCHAR (255)  NOT NULL DEFAULT HOST_NAME()
  )
  </code></pre>
  
  <p>But when I try to do an insert like:</p>
  
  <pre><code> INSERT INTO [UserLoginAudit]
                 VALUES
                      (
                      @EmpGuid
                     , @Today
                      )
  </code></pre>
  
  <p>It returns: </p>
  
  <blockquote>
    <p>Column name or number of supplied values does not match table
    definition.</p>
  </blockquote>
  
  <p>I check at <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/host-name-transact-sql?view=sql-server-2017" rel="nofollow noreferrer">docs</a> and I'm using column WorksStation with default value correctly, I don't have an idea why it does not allow me to insert that value default. Any ideas?</p>