hi,
In an UPDATE operation I want to update even the field(s) that are specified in the WHERE clause.
Update statement, i.e. for ex.
Update DEMO set AA=‘100’, BB=‘200’,CC=‘300’ where AA=‘50’ and DD=‘50’;
After executing UPDATE script, fields BB & CC will get updated but field AA is not getting updated.
Any tips are welcome.