Post reply

Suppress Warning during Update

  • May 14, 2013 at 12:21 pm

    #293957

    Hello Everyone

    I am updating one column with the data from another column, and I want to suppress the warning message about "data could be truncated"

    The column that will be updated is varchar(50), that column used as the source is varchar(100). When I preform an update, I am getting the warming message. How may I suppress the warning message and let the update complete?

    Thanks

    Andrew SQLDBA

  • May 14, 2013 at 12:29 pm

    #1615140

    Use SUBSTRING or LEFT to only pull the first 50 characters from the source column.

  • May 14, 2013 at 12:49 pm

    #1615154

    Thanks Lynn

    I was over thinking that one by a long way. And you came up with a result that is so simple.

    Thanks Buddy

    Andrew SQLDBA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply