Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @SaltCount INT;
- SELECT @SaltCount = COUNT(*) FROM tmp_NewLogin;
- PRINT 'Set Salt values for all records' + CAST(@SaltCount AS VARCHAR(10))
- DECLARE @CharPool CHAR(83);
- DECLARE @Salt VARCHAR(10);
- SET @CharPool = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789!"#$%&()*+,-./:;<=>?@';
- SET NOCOUNT ON;
- updateSaltValue:
- SET @Salt = ''
- SELECT @Salt = @Salt + SUBSTRING(@CharPool, number, 1) FROM
- (
- SELECT TOP 10 number FROM MASTER..[spt_values] WHERE TYPE = 'p' AND Number BETWEEN 1 AND 83
- ORDER BY NEWID()
- ) AS t
- UPDATE TOP(1) [table] SET [Salt] = @Salt WHERE [Salt] IS NULL
- IF (@@ROWCOUNT > 0)
- GOTO updateSaltValue
- SET NOCOUNT OFF;
- PRINT 'Completed setting salts for all records';
- create view [dbo].[wrapped_rand_view]
- as
- select rand( ) as random_value
- create function [dbo].[wrapped_rand]()
- returns float
- as
- begin
- declare @f float
- set @f = (select random_value from wrapped_rand_view)
- return @f
- select substring(replace(newid(),'-',''),0,10)
Add Comment
Please, Sign In to add comment