Skip to content

Instantly share code, notes, and snippets.

View swidz's full-sized avatar

Sebastian Widz swidz

3 followers · 34 following
View GitHub Profile
@swidz
swidz / random_from_list.sql
Created August 3, 2024 16:05 — forked from Tyriar/random_from_list.sql
Various T-SQL database obfuscation scripts
-- randomise a column's values using a list of specified values
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'ShuffleTable')
DROP TABLE [ShuffleTable];
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'InsertDataListTable')
DROP TABLE [InsertDataListTable];
GO
CREATE TABLE [InsertDataListTable] ([TargetColumn] NVARCHAR(50));