 |
Data Mask SQL |
| Home | |
|
Scrub.Null Sample SQL... /*==================================================================================== Mask Type: Scrub.Null =====================================================================================*/ /*--------------------------------------------------------------------- Table: [dbo].[AdventureWorksDWBuildVersion] Column: [VersionDate] Mask: * Type: 'Scrub: Null' * Category: 'Scrub' - overwrite all rows with "same" value * Descrip: This mask overwrites all rows with a NULL in this column ---------------------------------------------------------------------*/ UPDATE [dbo].[AdventureWorksDWBuildVersion] SET [VersionDate] = NULL |
