Column Level Encrypt & Decrypt (integer, numeric) fields

Question

Post reply

Column Level Encrypt & Decrypt (integer, numeric) fields

sethumail2000

SSC Enthusiast

Points: 127
More actions
May 1, 2020 at 2:36 pm

#3748076

Dear All,

How to encrypt column data types like (integer, numeric) in SQL server table level.
Kindly suggest
Sethu

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

sethumail2000 wrote:

Dear All,
How to encrypt column data types like (integer, numeric) in SQL server table level.
Kindly suggest
Sethu

This took me 15 seconds to Google. Please don't post questions which are so easily solved with a quick search.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

sethumail2000 SSC Enthusiast Points: 127 More actions · Answer 2

Hi Phil

Thanks for your quick reply.

I google this question and found some threads but can't match my requirement. That's why I posted here.

Will you please help me out.

Thanking you

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

Please tell me what is wrong with the information found by following the hyperlink I provided, and then we can help you further.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

sethumail2000 SSC Enthusiast Points: 127 More actions · Answer 4

Hi,

Have checked that link, the system suggests creating one more new field with datatype varbinary or varchar then encrypted data to store that field.

My database is running client environment and somany stored procedures and SQL statements written in pages also. I think I am not able to create new field as of now and migrate the data into new field. can you suggest to store the encrypted data into existing column

Like my table called users

Usercode int

Empid varchar

Name varchar

DOB smalldatetime

salary numeriic

I want to store encrypted data for following fields (usercode, empid, dob, salary)

Sethu

Phil Parkin SSC Guru Points: 246960 More actions · Answer 5

I can't think of a way of applying this sort of encryption without changing the structure of the database.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin