how to remove the end point in decimal column
Posted: Mon Dec 20, 2010 9:58 pm
I transcode a complex file to a sequential file without any change in column type.But I fail to load data from sequential file to SQL server by bcp
tool because there is a point "." at the end of decimal column(with decimalplace 0) such as decimal(8,0).
If I change the column type from decimal(8,0) to bigint, the problem dispears. But I have a lot of jobs and columns to edit.
I wonder if there is a better way?
tool because there is a point "." at the end of decimal column(with decimalplace 0) such as decimal(8,0).
If I change the column type from decimal(8,0) to bigint, the problem dispears. But I have a lot of jobs and columns to edit.
I wonder if there is a better way?