correcting the yml formatting
- name: Insert into sql server
community.general.mssql_script:
login_user: 'username'
login_password: "{{ mssql_login_password }}"
login_host: "{{ mssql_server }}"
login_port: "{{ mssql_port }}"
db: testdb
script: "insert into [Test].[RP].[ApplicationCategory] values
(NULL,NULL,'xyz','repo',NULL,getdate(),1,NULL,'xyz',NULL,'xyz')"
tags: jenkinsjob
On Friday, December 1, 2023 at 5:43:32 PM UTC-8 Narmada Karthika wrote:
> I am getting below error when trying to execute an Insert mssql query, the
> row is getting inserted but somehow failing with this
> Statement not executed or executed statement has no resultset
> this is my playbook
>
> - name: Insert into sql server
> community.general.mssql_script:
> login_user: 'username'
> login_password: "{{ mssql_login_password }}"
> login_host: "{{ mssql_server }}"
> login_port: "{{ mssql_port }}"
> db: testdb
> script: "insert into [Test].[RP].[ApplicationCategory] values
> (NULL,NULL,'xyz','repo',NULL,getdate(),1,NULL,'xyz',NULL,'xyz')"
> tags: jenkinsjob
>
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/421a3bf1-3cc9-4326-a420-05f16aacb9e3n%40googlegroups.com.
