BCP numeric data in scientific notation -
12-28-2010
, 03:03 PM
I have a process which writes a file to be bcp'd in. When I run the
bcp command I am using the character format (-c option), and I am
wondering about the behaviour when I encounter numeric values
represented in scientific notation.
I have noticed that for a column that is defined as "numeric(21,4)" I
can manually insert a value that is represented in scientific
notation, however in the bcp, I get an overflow error.
Is there any way that I can make the bcp command behave the same way
an insert statement would, when encountering scientific notation? |