creating an output variable azure devops from the Azure SQL InlineSqlTask task

0 votes

 YAML content :

- task: SqlAzureDacpacDeployment@1
  displayName: 'Azure SQL InlineSqlTask'
  inputs:
    azureSubscription: 'Service Connection'
    AuthenticationType: servicePrincipal
    ServerName: 'xxx.database.windows.net'
    DatabaseName: 'xxx-Dev'
    deployType: InlineSqlTask
    SqlInline: |
     select name as username,
                  create_date,
                  modify_date,
                  type_desc,
                  authentication_type_desc as authentication_type
                  from sys.database_principals where type_desc = 'EXTERNAL_USER'

I want to have the output of this t-SQL command stored in a variable. Can someone tell me how to do it?

Apr 21, 2022 in Other DevOps Questions by Kichu
• 19,040 points
803 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Other DevOps Questions

0 votes
1 answer

Azure DevOps yaml passing variable using "##vso[task.setvariable" not working

You can stop the pipeline from running ...READ MORE

answered Feb 8, 2022 in Other DevOps Questions by Bhavitha
• 1,000 points
1,843 views
0 votes
0 answers

How do I add the azure-devops commands to the Azure CLI in an offline on-premise server?

I wanted to add the azure-DevOps extension to the Azure ...READ MORE

Apr 19, 2022 in Other DevOps Questions by Kichu
• 19,040 points
558 views
0 votes
0 answers

Multiple YAML build pipelines in Azure DevOps

Using the new YAML way I want ...READ MORE

Mar 15, 2022 in DevOps Tools by Kichu
• 19,040 points
1,130 views
0 votes
0 answers
0 votes
0 answers
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP