What is the fastest to export output of a storedprocedure to a csv file using PowerShell
I have a SQL SERVER Stored procedure and it takes 4 minutes and output of this stored procedure is around 700k. WHat is fastest way to export to CSV using PowerShell. Any help is appreciated.
Microsoft SQL ServerPowershellSQL
Last Comment
Zberteoc
8/22/2022 - Mon
Elliott Clark
There's not much detail in your question, therefore I'll assume you just want to know the PowerShell command to export to CSV
Open in new window
at the end of your script and change the location to wherever you wish to CSV file to be exported to