lowlydba.sqlserver.nonquery (2.3.2) — module

Install collection

Install with ansible-galaxy collection install lowlydba.sqlserver:==2.3.2

Add to requirements.yml

  collections:
    - name: lowlydba.sqlserver
      version: 2.3.2

Description

Execute a nonquery against a database. Does not return a resultset. Ideal for ad-hoc configurations or DML queries.

Requirements

• L(dbatools,https://www.powershellgallery.com/packages/dbatools/) PowerShell module

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Update a table value
  lowlydba.sqlserver.nonquery:
    sql_instance: sql-01-myco.io
    database: userdb
    nonquery: "UPDATE dbo.User set IsActive = 1;"

Inputs

    
database:
    description:
    - Name of the database to execute the nonquery in.
    required: true
    type: str

nonquery:
    description:
    - The nonquery to be executed.
    required: true
    type: str

sql_instance:
    description:
    - The SQL Server instance to modify.
    required: true
    type: str

sql_password:
    description:
    - Password for SQL Authentication.
    required: false
    type: str

sql_username:
    description:
    - Username for SQL Authentication.
    required: false
    type: str

query_timeout:
    default: 60
    description:
    - Number of seconds to wait before timing out the nonquery execution.
    required: false
    type: int