|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > How change decimal separator ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How change decimal separator ?
|
|
|
| Hi to everybody, I have a little problem of configuration of the DB.
I have an input file which expresses decimal values with a comma as
separator.
Unfortunately I am not able to load these columns because the DB
requires decimal point instead .
How could I change the configuration of the DB (MS SQL Server 2000) to
force comma as decimal separator?
Thank's in advance, Max
| |
| P. Ward 2002-11-11, 6:23 am |
| The easiest way to do this is to use DTS (Data Transformation Services) and
Transform the data as it is copied from the source, that way transforming a
comma to a decimal on the fly.
Refer to transformations-DTS in SQL Server Books on Line and www.sqldts.com
is a good reference for DTS.
"Pluto" <maxroma23@yahoo.it> wrote in message
news:16adcda3.0211110216.6209f4c1@posting.google.com...
> Hi to everybody, I have a little problem of configuration of the DB.
> I have an input file which expresses decimal values with a comma as
> separator.
> Unfortunately I am not able to load these columns because the DB
> requires decimal point instead .
> How could I change the configuration of the DB (MS SQL Server 2000) to
> force comma as decimal separator?
> Thank's in advance, Max
|
|
|
|
|