Category : sql-server

Trying to insert into temp tables with SQLAlchemy (plugged into PYODBC/sql server) and inserting more than one row with decimal values and fast_executemany=True throws: ProgrammingError("(pyodbc.ProgrammingError) (‘Converting decimal loses precision’, ‘HY000’)") This happens only in temp table with fast_executemany=True and multiple rows being inserted at once with one column being decimal. Inserting one at a time, ..

Read more

I have a time series plc tag data as below with values in ‘1’ or ‘0’ | id | tagname | value | datetime | |—-|—————————–|——-|————————-| | 28 | RH.ONCHANGE.PROCESS_CYCLE_4 | 1 | 28-09-2021 17:43:38.767 | | 29 | RH.ONCHANGE.CYCLE_COMPLETE | 0 | 28-09-2021 17:44:07.637 | | 30 | RH.ONCHANGE.PROCESS_CYCLE_4 | 0 | 28-09-2021 17:44:01.723 ..

Read more

This is the query I am sending: SELECT "*" FROM "tkscale" WHERE "UfText1" IN ("12","23","45","0"); But I am getting the following error. Error (pymssql._pymssql.ProgrammingError) (207, b"Invalid column name ‘0’.DB-Lib error message 20018, severity 16:nGeneral SQL Server error: Check messages from the SQL ServernDB-Lib error message 20018, severity 16:nGeneral SQL Server error: Check messages from the ..

Read more