SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Updating a column


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.


No comments.

Leave a Comment

Please register or log in to leave a comment.