lowlydba / lowlydba.sqlserver / 2.3.2 / module / nonquery Executes a generic nonquery | "added in version" 0.1.0 of lowlydba.sqlserver" Authors: John McCall (@lowlydba)lowlydba.sqlserver.nonquery (2.3.2) — module
Install with ansible-galaxy collection install lowlydba.sqlserver:==2.3.2
collections: - name: lowlydba.sqlserver version: 2.3.2
Execute a nonquery against a database. Does not return a resultset. Ideal for ad-hoc configurations or DML queries.
- name: Update a table value lowlydba.sqlserver.nonquery: sql_instance: sql-01-myco.io database: userdb nonquery: "UPDATE dbo.User set IsActive = 1;"
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