GitHub

Can't insert string value and null value to decimal column in same insert

Python: 3.7.0 64-bit pyodbc: 4.0.23 OS: Windows 10 Professional DB: SQL Server 2017 driver: ODBC Driver 11/13/17 for SQL Server; SQL Server Native Client 11.0 When doing a single insert containing ...
GitHub

Decimal value converted to Exponential value for some values only

If a database table value contains 6 or more digits after the decimal place, the value gets converted to exponential value. Data is stored in SQL Server DB. Sql script - contains the table and insert ...