 |
Data Mask SQL |
| Home | |
|
Scrub.EmptyString Sample SQL... /*==================================================================================== Mask Type: Scrub.EmptyString =====================================================================================*/ /*--------------------------------------------------------------------- Table: [dbo].[AdventureWorksDWBuildVersion] Column: [VersionDate] Mask: * Type: 'Scrub: Empty String' * Category: 'Scrub' - overwrite all rows with "same" value * Descrip: This mask overwrites all rows with '' in this column; where '' is the empty string, used where nulls not allowed ---------------------------------------------------------------------*/ UPDATE [dbo].[DatabaseLog] SET [DatabaseUser] = '' |
