Encrypted data getting changed

Question

Hi All am writting an Update query Which will set data to password colomn this data is encrypted and am updating data accross database (from 1db to other db). UPDATE dbname.dbo.tblnm SET PwdCol=(Select PwdCol FROM tblnm WHERE pkCol=11111) WHERE pkCol=11111

Amit Choudhary · Answer

What encryption strategy are you using in you table? Go through the details of that strategy see if something is breaking on updation or what was taken into account when you have inserted a new records see if it's missing when you are updating the same record.

Encrypted data getting changed

Hi All,am writting an Update query Which will set data to password colomn, this data is encrypted and am updating data accross database (from 1db to other db).UPDATE dbname.dbo.tblnm SET PwdCol=(Select PwdCol FROM tblnm WHERE pkCol=11111) WHERE pkCol=11111

Hi All,
am writting an Update query Which will set data to password colomn, this data is encrypted and am updating data accross database (from 1db to other db).
UPDATE dbname.dbo.tblnm SET PwdCol=(Select PwdCol FROM tblnm WHERE pkCol=11111) WHERE pkCol=11111