Marc Petros

Junior DBA

Marc Petros is a junior DBA for XTIVIA, primarily working with Db2 for the VDBA team. He’s well-versed in Db2 and also has significant experience in PostgreSQL and Microsoft SQL Server. With a certification in MS MTA database fundamentals — and working towards his Db2 LUW Fundamentals certification — Marc scripts, sets permissions, and maintains client records/settings for VDBA. In his free time, he enjoys reading, writing, and spending time with his two children.

Why won’t SQL accept my value? Msg 8115, Level 16, State 8

Arithmetic overflow error; converting it to data type numeric Understanding Decimal and Numeric arguments The problem: Entering a number in a field that is data type of decimal (5, 3) works for values like [85.200] but not others like [500]. The Cause: The arguments... read more