Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Generating Hex on Insert RE: Generating Hex on Insert

  • August 4, 2014 at 10:06 pm

    #1734990

    mike 57299 (8/4/2014)

    I get the following error with the code from Ten Centeries:

    Msg 515, Level 16, State 2, Line 1

    Cannot insert the value NULL into column 'scancode', table 'Solovue_Homart.dbo.scancode'; column does not allow nulls. INSERT fails.

    The statement has been terminated.

    I think it is because the primary key (an identity column) doesn't populate until after the save.

    Mike

    The scancode column is defined as NOT NULL. The insert has to pass any value such as a blank string ('') to bypass this.

    😎