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/05b03769-32fb-427b-889c-e5ade3b7767bn%40googlegroups.com.
