How to write the Following Equevalant Query

• amitsingh308

  Ten Centuries

  Points: 1287

  More actions

  October 3, 2013 at 4:38 am

  #277751

  Hi,

  can anyone provide me the equivalent MS SQL server query for the following query:

  LOAD DATA LOCAL INFILE '/tmp/ state_reg_photo.csv.csv'

  INTO TABLE REGISTRAR_REPORTS.srdh_photodata

  FIELDS TERMINATED BY ','

  ENCLOSED BY '"'

  LINES TERMINATED BY ''

  (uid,imagedata);

• mahmad_khoja

  SSCommitted

  Points: 1511

  More actions

  October 3, 2013 at 4:48 am

  #1655491

  You can use BCP command for this.

  Try searching use of BCP command.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  October 3, 2013 at 5:03 am

  #1655497

  You may want to look at BULK INSERT:

  http://msdn.microsoft.com/en-us/library/ms188365(v=sql.110).aspx/html