Friday, 18 December 2020

Export data from stored procedure to CSV

 -- xp_cmdshell must be enabled under server security

DECLARE @cmd as varchar(4000) = 'BCP "Exec BikeStores.dbo.Test" QUERYOUT "D:\1.csv" -c -t\^, -T -S' + @@servername

EXEC master..xp_cmdshell @cmd



No comments:

Google Form using App Script

Create a Google Sheet with the following headers: First Name, Last Name, DoB Create a Google Form with the exact headers as Google Sheet he...