语句如下:
bulk insert table
from 'C:\abc.txt'
with (fieldterminator=',',firstrow=1)
提示出错:列太长。请确保正确地指定了字段终止符和行终止符。
于是换成:
bulk insert table
from 'C:\abc.txt'
with (fieldterminator=',',ROWTERMINATOR ='0x0a',firstrow=1)
替换的地方在于ROWTERMINATOR ='0x0a'
语句如下:
bulk insert table
from 'C:\abc.txt'
with (fieldterminator=',',firstrow=1)
提示出错:列太长。请确保正确地指定了字段终止符和行终止符。
于是换成:
bulk insert table
from 'C:\abc.txt'
with (fieldterminator=',',ROWTERMINATOR ='0x0a',firstrow=1)
替换的地方在于ROWTERMINATOR ='0x0a'