Incorrect Syntax near 'LOAD'

[aafaq]

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

LOAD DATA LOCAL INFILE 'PATH' INTO TABLE test FIELDS terminated by '\r\t';

[Rabbit]

There is no load data infile syntax in SQL server. That's mysql syntax.