How can we help you today? How can we help you today?

Save File with Customer Delimiter

We have the need to save a set of results to a file using a Custom Delimiter. In our case, the file needs to be delimited with a semi-colon. Management Studio has this option, so we’ll get it done, but we will need to run the query once for each of our 43 databases. If we could use SQL Multi Script, that would be wonderful!

Is there a way to do this in SQL Multi Script that we haven’t found?

Maybe this option is already in development?
sjacker
0

Comments

1 comment

Sort by
  • Andrew P
    Hello Sjacker,

    Thanks for reaching out to us!

    Currently you cannot specify a custom delimiter within Multiscript, but you might be able to output to a .csv file then do a "Find And Replace All" with Notepad++ to get the formatting right. In any case I have submitted a feature request SE-684, so it is up to the project managers to triage accordingly.

    Please let me know if you have any questions.

    Warmly,
    Andrew Pierce
    Product Support Engineer - Redgate
    Andrew P
    0

Add comment

Please sign in to leave a comment.