Posted on 2014-08-07
My sql server 2008 database - Emp Salary table has Salary field Decimal(18,2)
I need to Encrypt this Values
I used EncryptByPassPhrase('123456', Salary)
Error : Argument data type int is invalid for argument 2 of EncryptByPassPhrase function.
yes i undertsand the error ,But problem is i can't change the Salary field type. so Can any one come up with good option
or how to deal with this issue, if i change this field all the report will effect more than 100 reports.
so i don't want salary field Type. and Not Allowed also.(No permission)
Any idea will highly appriciate.thx