New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
MSSQL Module does not support UPDATE statements #52831
Comments
|
I believe the main reason for that behavior is that
and for any queries that actually modifies the data you also need to call i see how difficult it is to determine query type inside |
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. If this issue is closed prematurely, please leave a comment and we will gladly reopen the issue. |
Thank you for updating this issue. It is no longer marked as stale. |
@rdutch The issue is still present, I'm facing this problem now. `
` Probably I will do a custom function specific to deal with INSERTS, to avoid changing def tsql_query |
I would like to do a pull request to fix this issue. I added a new function called "mssql.update_query" with the changes mentioned by @amalaguti last year. I spent hours trying to get this to work before finding this. Is there a branch I should use for this PR? |
The current (2019.2.0)
mssql
module does not support UPDATE statements, they return empty and no UPDATE happens. Example: UPDATE testtable set test1='Apples'This missing functionality is very important to be able to update certain tables which are used for configuration settings as part of a application.
The current workaround is to use a power shell script.
The text was updated successfully, but these errors were encountered: