SQL table to text file

• sheetalnc.8585

  Grasshopper

  Points: 16

  More actions

  June 12, 2009 at 2:26 am

  #384763

  Hi,

  Please could you help me create a stored procedure to get the entire data from a SQL table into a text file. The column values should be separated by comma and the column names should also be retrieved.

  The tables would not be the same everytime I execute the procedure thus it should be flexible enough.

  Let me know if you need more details.

  Thank you

• BrainDonor

  SSCoach

  Points: 19254

  More actions

  June 12, 2009 at 2:49 am

  #1008443

  http://www.sqlservercentral.com/scripts/BCP/65710/

  Using bcp and xp_cmdshell.

  Steve Hall
  Linkedin
  Blog Site

• Vee

  Hall of Fame

  Points: 3028

  More actions

  June 12, 2009 at 9:55 am

  #1008767

  You can us my script. It even gets you column names also.

  http://www.sqlservercentral.com/scripts/Replication/31668/