Incorrect update

  • 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.

  • 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 2 (of 2 total)

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