Post reply

Incorrect update

  • April 13, 2021 at 4:17 pm

    #3870607

    Hello, I made mistake during updating cells in table.In column that contains int type, with 'update' statement, I put varchar type. I am tring to correct this, but I recive error: Conversion failed when converting the varchar value 'TEXT' to data type int.

  • April 13, 2021 at 4:28 pm

    #3870610

    Correct.

    You will need to either delete rows with conflicting data (if you can get away with that... you might want to copy the data to an error table to review later), or update the non-integer values to some integer value, before altering the column.

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

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