 |
Data Mask SQL |
| Home | |
|
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) |
