I have a lengthy script that tries to insert float values with quotes (ie. '15.6') in float fields using T-SQL.
I have reasons to believe this script works in its developer machine, but because of the quotes it fails on my SQL Server 2008.
Is there any way to configure my server to ignore those quotes when the column is numeric? That would be much easier than editing the script.
It happens that the quoted values are automatically converted to numbers if required.
I didn't happened to me before because my machine was configured with a different decimal separator than the developers machine.
Now that I changed the Regional settings in the control panel, everything works.