April 13, 2021 at 4:17 pm
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy