Posted by Roy Harvey on 06/29/06 21:45

What is the definition of dbo.table?

Roy

On 29 Jun 2006 11:40:22 -0700, "sql guy123" <stoppal@hotmail.com>
wrote:

>
>In addition, I have a CSV file with data like 10.20, which I import
>inrto a numberic field. Unforunately the value gets changed to 10.
>It's seems to get rounded. How can I fix this.
>The import SQL I use is....
>
>BULK INSERT dbo.table
> FROM 'c:\MYDATA.CSV
> WITH
> (
> FIRSTROW = 1,
> FIELDTERMINATOR = ',',
> ROWTERMINATOR = '\n'
> )

[Back to original message]