Windows Test Gear - MSSQL.DataMask - Transform.Hash Sample SQL

	Data Mask SQL
	Home

Transform.Hash

Sample SQL...

/*===================================================================================
Mask Type: Transform.Hash =====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DimAccount]
Column: [CustomMemberOptions]
Mask:
* Type: 'Transform: Hash (MD5)'
* Category: 'Transform' - Overwrite all rows with an "obsfucated" original value
* Descrip: This mask transforms each row by hashing it. It generates an 'almost'
unique 16-byte hash if the column is wide enough; if not, then take
N left-most characters from the hash. It uses the MD5 hash algorythm.
---------------------------------------------------------------------*/
UPDATE [dbo].[DimAccount]
SET [CustomMemberOptions]
= CAST(HashBytes('MD5', [CustomMemberOptions]) AS VARCHAR(40));