Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) String or binary data would be truncated. Error when inserting empty table results into TEMP table RE: String or binary data would be truncated. Error when inserting empty table results into TEMP table

  • October 27, 2016 at 4:19 pm

    #1909260

    steve.bradford (10/27/2016)

    Are any records returned if you use DATALENGTH(ID) > 15? LEN() automatically trims.

    Since this thread is almost three years old and the OP hasn't made any recent updates, it's likely that this was resolved a long time ago.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA