Incorrect update

• marcin89

  SSC Rookie

  Points: 32

  More actions

  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.

• ratbak

  Default port

  Points: 1411

  More actions

  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.