请试下面这个
c:\myfile.txt中内容为:
a
b
c
d
edrop table a
gocreate table a
(a varchar(200)
)
goBULK INSERT pubs..a FROM 'c:\myfile.txt'
WITH (FIELDTERMINATOR='¦',ROWTERMINATOR='|n')
goselect * from a
c:\myfile.txt中内容为:
a
b
c
d
edrop table a
gocreate table a
(a varchar(200)
)
goBULK INSERT pubs..a FROM 'c:\myfile.txt'
WITH (FIELDTERMINATOR='¦',ROWTERMINATOR='|n')
goselect * from a
Server: Msg 4860, Level 16, State 1, Line 1
Could not bulk insert. File 'c:\windows\desktop\myfile.txt' does not exist.