Tag Archives: Learn the database in three minutes

Arithmetic overflow error converting numeric to data type numeric.


Run the stored procedure when found this error, the stored procedure for thousands of lines of code, scan the stored procedure will find storage process is divided into several parts, the wrong time, I will COPY the original stored procedure, then a part of a part of the add up, and every part of add, will carry out this part of the code, the final positioning in the sixth part, and then a field continue to locate a field, and finally, positioning the two fields has a problem, as shown in figure

After locating this problem, I checked the data:


 
And then look at the table structure: