When types.name = 'nvarchar' then columns.max_length / 2 Return left(SUBSTRING(_varbintohexstr(HashBytes('SHA1', cast(cast(cast(dbo.randUniform() * 10000 as int) as varchar(8)) as varchar(40)) + 3, 32), transaction If exists (select 1 where object_id('randUniform') is not null)Ĭreate view random(value) as select rand() Ĭreate function dbo.randUniform() returns real If exists (select 1 where object_id('random') is not null) If exists (select 1 where object_id('fnGetSanitizedName') is not null) if exists (select 1 where object_id('tempdb.#columnsToUpdate') is not null)Ĭreate table #columnsToUpdate(tableName varchar(max), columnName varchar(max), max_length int) I made a fairly basic scramble function that will just sha1 the data (with a random salt) so that it should be secure enough for most purposes.
#Unscramble decibel update#
WHERE value."type" = 'P' -Limit "number" to integers between 0-2047Īnd value.number <= can create a list of the columns that need updating and then simply iterate over said list and execute some dynamic sql that will update the row in some fashion.
Where value."type" is not null -refer to outer query, to get different value for each row , CONVERT(NVARCHAR(max), crypt_gen_random( (ABS(CHECKSUM(NewId())) % * 2))+1 )) as RandomLengthUnicode , CONVERT( VARCHAR(max), crypt_gen_random( (ABS(CHECKSUM(NewId())) % )+1 )) as RandomLengthText , ( select value."type" is not null -refer to outer query, to get different value for each row , CONVERT(NVARCHAR(max), crypt_gen_random( * 2 )) as FixedLengthUnicode Here are couple simple methods that have quite nice performance and can be applied to a table: use master ĭeclare as int = 50 -acts as maximum length for random length expressionsĬONVERT( VARCHAR(max), crypt_gen_random( )) as FixedLengthText
0 kommentar(er)
