The Story of Precision, Scale, and Length in SQL Server
Hi guys, Did you ever faced issues with BIG mathematical figures – related to either overflow or any other arithmetic errors. This may be applicable to SQL arithmetic operations or arithmetic operations you do with SQL table in SSIS etc. Well, check 1 more time, if you have any issues in your database design related to column data type which stores the BIG numbers. I ran into this issue couple of times, and reason behind this issue was same all the time. So decided to do a quick post. And that reason is “Improper or insufficient precision, scale and length defined for storing … Continue reading →