May 26, 2015 at 10:50 am
Hi, I ran a db update script to update the datatype for a column from a tinyint to a smallint:
ALTER TABLE MyTable
ALTER COLUMN Age smallint
Then I ran another db update script to update the value in these 2 columns:
update MyTable
set Age = Age * 12,
However, the second db update script returns the following error:
Msg 220, Level 16, State 2, Line 1
Arithmetic overflow error for data type tinyint, value = 1440.
The statement has been terminated.
SSMS shows the column with the new data type of smallint. I even restarted SSMS but I still get the error above. 1440 is out of range for a tiny int but should be in range for a smallint. Any idea what this issue might be? Both scripts need to be executed together in sequence by the release manager.
May 26, 2015 at 11:00 am
Confirm there is not a trigger on this table, or some other change data capture mechanism, that inserts into an audit table for which the datatype of Age is still tinyint.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply