DECLARE @x FLOAT = 1.0; SELECT SIN(2 * @x) + COS(3 * @x) + 4 - POWER(85, 3) AS f_value; If run through MS SQL Server Management Studio, the query completes successfully: If, however, this same query ...
I assume Heidi uses varchar literals to insert data into MSSQL. You cannot do this. You cannot do that because varchar literals are lossy when they contain data outside of the current codepage. For ...