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 ansible-project+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/421a3bf1-3cc9-4326-a420-05f16aacb9e3n%40googlegroups.com.