By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,341 Members | 1,553 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,341 IT Pros & Developers. It's quick & easy.

Incorrect Syntax near 'LOAD'

P: 1
Hi,

I am working on SQL 2008 database. In Micosoft SQL server Management studio, i am trying to LOAD data in a table, using this query. It show

Expand|Select|Wrap|Line Numbers
  1. LOAD DATA LOCAL INFILE 'PATH' INTO TABLE test FIELDS terminated by '\r\t'; 
Aug 7 '15 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,430
There is no load data infile syntax in SQL server. That's mysql syntax.
Aug 7 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.