I have a table name CustUsers. In this table, there is a field name: PWD
I have refreshed the production database into the test. This field has about 200 records and these records are passwords created by users from the application. When i restored the prod database into the test, there will be 200 passwords. I want to keep just one password for all of the users in the test database for the testing purpose and to troubleshoot database issues, and i want all users to use the same password. How can i update these 200 records in the test database table?
Thanks for your help and let me know if the question is not clear.