How to hash 2 columns of SQL table
I have a MS SQL table, let's called it "year_end", there is a column with sensitive data called "customer ID", I would like to hash the "customer ID" column by the identity column and then load it into a new table row by row with the hash result. Example:
The "year_end" table:
The new "year_end" table:
customer_ID ???? (hash value)
I need the codes in C# to do this. Do I use Console application to do this or ASP.NET? I am new to C#.
Thanks in advance.