What do I need to change in Sql Server to be able to store values like "2,1" in a decimal field? Right now I have to have dots like "2.1".
I have Finnish_Swedish_CI_AS collation on the database but that doesn't seem to be it ... I also fiddled around with the regions settings on the server but with no success. I know I've managed to change this before.
In security, your login properties, set default language to Finnish or Swedish. Although I'd prefer to format values into english standard and have default language set to english - this way storing data is independent of client regional settings.
Store the data as a regular number - change it only when you display it.
As i side, if you wished to convert the dot to a comman in a stored proc, then you could use something like this.
DECLARE @numtest as DECIMAL(10,3)
SET @numtest = 123.456
SELECT @numtest -- decimal with dot
SELECT REPLACE(CONVERT(VARCHAR(13), @numtest), '.', ',') -- String with comma