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