The Procedure That Selects Random Number Between the Two Numbers Entered as Parameters In Sql

In this article we’ll learn the procedure that selects random number between the two numbers entered as parameters.

Create Procedure Sp_Random_Value 
@first int,
@second int,
@result int output
As
Begin
     Set @result =Floor(RAND() * (@second-@first))+@first
End

Create Procedure Sp_Random_Value

@first int,

@second int,

@result int output

Begin

Set @result =Floor(RAND() * (@second-@first))+@first

End

After getting succesful message we can run the below code to get random values. You can enter deferent values.

Declare @r int
Execute Sp_Random_Value 20,30,@r output
Select @r

Declare @r int

Execute Sp_Random_Value 20,30,@r output

Select @r

Each time you run the code, you will receive different values between 20 and 30.

I got the result : 23