IF ISNULL(object_id('cspRandomString'),0)<>0 DROP PROC cspRandomString IF ISNULL(object_id('fnGenRandomInteger'),0)<>0 DROP FUNCTION fnGenRandomInteger GO CREATE function fnGenRandomInteger(@MinValue int, @MaxValue int, @Seed float) returns int as begin -- ============================================= -- Author: Loh Hon Chun -- ============================================= return ((@MaxValue + 1) - @MinValue) * @Seed + @MinValue end go CREATE procedure cspRandomString ( @Result varchar(255) output, @AcceptedChars varchar(255), @Length int ) as begin -- ============================================= -- Author: Loh Hon Chun -- ============================================= set nocount on declare @ret char(255) declare @i int, @pos int set @Result = '' set @i = 0 if LEN(@AcceptedChars) > 0 begin while @i < @Length begin set @pos = dbo.fnGenRandomInteger(1, LEN(@AcceptedChars), RAND(CONVERT(VARBINARY, NEWID()))) set @Result = @Result + CAST(SUBSTRING(@AcceptedChars, @pos, 1) AS VARCHAR(1)) set @i = @i + 1 end end end go declare @result varchar(255) declare @acceptedChars varchar(255) declare @length int set @acceptedChars = '0123456789' set @length = 7 exec cspRandomString @Result=@result output, @AcceptedChars=@acceptedChars, @Length=@length print @result go
Computer, Technology, Databases, Google, Internet, Mobile, Linux, Microsoft, Open Source, Security, Social Media, Web Development, Business, Finance
Sunday, May 26, 2013
MSSQL: Generate Random String Using SQL
The following will generate a random fixed-length string using SQL. Simply pass in a string of accepted characters and the length of the random string to be generated.
Subscribe to:
Post Comments (Atom)
-
This post contains information about registration for Wireless@SG account. Sign Up You can sign up a total of 3 user accounts, one each ...
-
Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed m...
-
The Mashable published 10 Chrome extensions for web developers and I bet web developers like you yourself must be using some of them. Do yo...
-
Since Google Reader started 8 years ago, I have been a great fan of it, using it on a daily basis. It is indeed sad to hear we will have to ...
-
Gartner Report on the Magic Quadrant for Analytics and Business Intelligence Platforms as of February 2021.
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.