Question on Encryption

SQL Server Administration
1

I inherited a table that has a column that holds passwords. I never dealt with this before. My questions are:
How could I insert a new record with a password in here?
How would I be able to update a password for an existing one?
Is there a way to see the existiing ones?

Thank you

2

If they are encrypted you must decrypt to see them and encrypt the updated or new passwords for insert.

3

thanks but how would you do that?

4

How is the password column encrypted?

5

Hi, I am sorry I have no information I just inherited the table. Is there a standard process for decrypting, updating the column?

6

You need to know how it is encrypted and the key.

7

Unless it was done properly and they are only storing the hash - which cannot be decrypted.

8

thank you