Save results as...

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  November 22, 2016 at 9:31 am

  #323288

  In SQL manage studio result panel, right click the result, select "Save results as...", I can save result as csv file.

  How to generate SQL statement from there to create a store procedure?

• Eirikur Eiriksson

  SSC Guru

  Points: 182944

  More actions

  November 22, 2016 at 9:40 am

  #1914048

  adonetok (11/22/2016)

  ---

  In SQL manage studio result panel, right click the result, select "Save results as...", I can save result as csv file.

  How to generate SQL statement from there to create a store procedure?

  No, not without concatenating the column values with the delimiter and then use result to a file. The caveat is that this way there will be one column header for all the output but you can always remove the first two rows, the column header and the -----------.