How to run a stored procedure with parameters using bcp command against SQL Azure database
I have a stored procedure which needs 2 mandatory input parameters. I need to run that stored procedure using bcp command and export the results to a csv file.
Note: the stored procedure is hosted in a SQL Azure instance for which I only have Azure AAD Authentication to my account. UserName and Password Auth is not allowed.
This bcp command is running fine to export data from a table. but I'm unable to execute stored procedure with 2 input parameters.
bcp DatabaseName.domain.MyTableName
out V:\MyDocuments\SourceType.csv
-U viratkohli@conco.com -S Servername.database.windows.net -G -c -t","
What I am expecting to work for stored procedure:
bcp DatabaseName.dbo.MyStoreProcedure 'Parameter1','Parameter2'
out V:\MyDocuments\SourceType.csv
-U viratkohli@conco.com -S Servername.database.windows.net -G -c -t","
or:
$SqlQuery = "DatabaseName.dbo.MyStoreProcedure 'Parameter1','Parameter2'"
bcp $SqlQuery out V:\MyDocuments\SourceType.csv -U viratkohli@conco.com -S Servername.database.windows.net -G -c -t","
Solution
To run a stored procedure with parameters using bcp command against SQL Azure database follow below command:
bcp "exec databas-ename.schema-name.SP-name 'Param1','Param2'" queryout "path of file" -S servername.database.windows.net -d dbname -U username -G -c -t","
Execution:
Output:
- PowerShell: Refreshing date stored in a variable
- In PowerShell how to compare Invoke-WebRequest content to a string
- Powershell send-mailmessage - email to multiple recipients
- Powershell: replace every line that contains a given string
- Create a string synopsis
- How to Combining PowerShell Output from multiple server to Single csv
- Ignore SSL warning with powershell downloadstring
- Error 'Install-Module is not recognised.' when Linux Azure App Service tries to install PS module
- I cannot extract .sql CREATE TABLEs for each table in my Azure SQL Database in my Azure Repo
- Does there exists a PowerShell Escape function for Special Characters
- Add SourceTree Remotes Programmatically
- Powershell $PROFILE variable pointing to wrong location. Where is $PROFILE variable it set?
- How to convert any timestamp of a given timezones into UTC?
- Modify OuterXml of a given node to keep it in file, but render node useless
- Is it possible to use comments in Powershell multiple line commands?
- Kill process based upon process Id powershell - xaml listview
- Or clause in Get-CimInstance filter
- Why do I need to use 'parametersetname' with a PowerShell switch?
- Powershell how to get the ParentProcessID by the ProcessID
- How do I add an atomic counter to a powershell ForEach -Parallel loop
- Copy/clone folder permissions to another folder (Windows)
- extract specific string from the field returned
- Use PowerShell for Visual Studio Command Prompt
- Connect to wireless network
- What's the environment variable for the path to the desktop?
- Powershell, write creation of environment variables to file
- Exporting Data to Tables from PNP Powershell
- Get-MgGroupMember by display name instead of userID
- Azure DevOps REST API parent relation link to existing work item error
- How to get list of users from CSV file whose LastSignInDate column has a date that is before 90 days from current date or is empty?