0

Dear Guys I Want To Generate A Random Number Between 2 Number BUT Without Generating 2 Same Number I Mean If For Example Already Generated Number "2" Next Time Did Not Generate It , Is There Any Solution :icon_question:

3
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by JasonHippy
0

U can make use of SQL to generate random strings/numbers. I have patsted to sql query below; hope it helps.

CREATE procedure dbo.GenerateRandomString (@useNumbers bit, @useLowerCase bit, @useUpperCase bit, @charactersToUse as varchar(100), @passwordLength as smallint, @password varchar(100) OUT)
As
Begin
if @passwordLength <= 0
raiserror('Cannot generate a random string of zero length.',16,1)

declare @characters varchar(100)
declare @count int

set @characters = ''

if @useNumbers = 1
begin
	-- load up numbers 0 - 9
	set @count = 48
	while @count <=57

	begin
		set @characters = @characters + Cast(CHAR(@count) as char(1))
		set @count = @count + 1
	end
end

if @useLowerCase = 1
begin
	-- load up uppercase letters A - Z
	set @count = 65
	while @count <=90
	begin
		set @characters = @characters + Cast(CHAR(@count) as char(1))
		set @count = @count + 1
	end
end

if @useUpperCase = 1

begin
	-- load up lowercase letters a - z
	set @count = 97
	while @count <=122
	begin
		set @characters = @characters + Cast(CHAR(@count) as char(1))
		set @count = @count + 1
	end
end

set @count = 0
set @password = ''
-- If you specify a character set to use, the bit flags get ignored.
if Len(@charactersToUse) > 0
	begin
		while charindex(@charactersToUse,' ') > 0
			begin
			 set @charactersToUse = replace(@charactersToUse,' ','')
			end
		if Len(@charactersToUse) = 0
			raiserror('Cannot use an empty character set.',16,1)
		while @count <= @passwordLength
			begin
				set @password = @password + SUBSTRING(@charactersToUse,CAST(ABS(CHECKSUM(NEWID()))*RAND(@count) as int)%LEN(@charactersToUse)+1,1)
				set @charactersToUse = left(@charactersToUse,CAST(ABS(CHECKSUM(NEWID()))*RAND(@count) as int)%LEN(@charactersToUse)) + right(@charactersToUse,LEN(@charactersToUse)- CAST(ABS(CHECKSUM(NEWID()))*RAND(@count) as int)%LEN(@charactersToUse)+2) 
				set @count = @count + 1
			end
	end
else
	begin
		while @count <= @passwordLength
			begin
				set @password = @password + SUBSTRING(@characters,CAST(ABS(CHECKSUM(NEWID()))*RAND(@count) as int)%LEN(@characters)+1,1)
				set @count = @count + 1
			end
	end
end

GO:icon_cool:

0

Dear Guys I Want To Generate A Random Number Between 2 Number BUT Without Generating 2 Same Number I Mean If For Example Already Generated Number "2" Next Time Did Not Generate It , Is There Any Solution :icon_question:

There are loads of ways to generate unique random numbers, but what language are you trying to this in? Javascript? Flash/Actionscript? C#? VB.NET? Python? PHP? etc etc....

Note: This is the web development->graphics and multimedia forum...
So if it's flash/actionscript related then you're in the right place. But if it's any of the other languages mentioned above, there are dedicated forums for them and you should probably ask there instead!

Cheers for now,
Jas.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.