Data Mask SQL

 
 

Scrub.FixedString

Sample SQL...

/*===================================================================================
 Mask Type: Scrub.FixedString
=====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DatabaseLog] Column: [Event] Mask:
* Type: 'Scrub: Fixed String...'
* Params: 'Event'
* Category: 'Scrub' - overwrite all rows with "same" value
* Descrip: This mask overwrites all rows with a fixed string in this column; where
  fixed string is text you enter Note that the text value is truncated by the width
  of the column's data length (prevent user from entering too large of a string
  that would error the tSQL)
---------------------------------------------------------------------*/

UPDATE [dbo].[DatabaseLog]
SET [Event] = LEFT('Event', 128)
 
 

eXTReMe Tracker