reading/writing result set in a file in a SP

• bharat-223773

  Newbie

  Points: 1

  More actions

  April 10, 2005 at 12:34 pm

  #88049

  I an new to SQL server and was wondering if it is possible for me to run queries in a SP and write the result set to a file (lets say ASCII file). Later, can I read data from this ascii file in the SP and then lets say use it to insert values in some tables? Is it possible to do this?

• addie

  SSC Veteran

  Points: 224

  More actions

  April 10, 2005 at 1:58 pm

  #551757

  You can use BCP and Bulk Insert to extract data to a file or Import data from a file into a table.

  Look up both BCP and Bulk Insert commands in BOL

   

  ---

  Regards,

  Aditee Rele

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  April 11, 2005 at 8:39 am

  #551858

  Both of those require special privleges, which I normally don't give out.

  Why do you need to work with a text file? Can you not store these values in a table?