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



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Setup PowerShell Universal Dashboard

# Run PowerShell as Administrator Install-Module -Name UniversalDashboard.Community # Check PowerShellGet version Get-Module -Name PowerShel...