Home Forums SQL Server 2008 SQL Server 2008 - General Concatenate IN TRIGGER two fields into one in this line of the TRIGGER T-SQL?: RE: Concatenate IN TRIGGER two fields into one in this line of the TRIGGER T-SQL?:

  • November 12, 2012 at 3:02 pm

    #1558333

    Both the PO_Number and HeatTicketNumber are already Varchar as the table datatype... so (?) no need for conversion (?)...

    I ran the code above and now have a SQL error popping up from my ASp.net app:

    String or binary data would be truncated.

    The statement has been terminated.