SQLGenerate Random Number Between the Two Numbers Entered in SQL Stored Procedure5 years agoAdd Commentby adminIn this article we’ll learn the procedure that selects random number between the two numbers entered as parameters.Transact-SQL Create Procedure Sp_Random_Value @first int, @second int, @result int output As Begin Set @result =Floor(RAND() * (@second-@first))+@first End 12345678910 Create Procedure Sp_Random_Value @first int,@second int,@result int outputAsBegin Set @result =Floor(RAND() * (@second-@first))+@firstEnd After getting succesful message we can run the below code to get random values. You can enter deferent values.Transact-SQL Declare @r int Execute Sp_Random_Value 20,30,@r output Select @r 12345 Declare @r intExecute Sp_Random_Value 20,30,@r outputSelect @r Each time you run the code, you will receive different values between 20 and 30. I got the result : 23Transact-SQL Declare @r int Execute Sp_Random_Value 20,30,@r output Select @r 12345 Declare @r intExecute Sp_Random_Value 20,30,@r outputSelect @r Result : 20Transact-SQL Declare @r int Execute Sp_Random_Value 20,30,@r output Select @r 12345 Declare @r intExecute Sp_Random_Value 20,30,@r outputSelect @r Like this:Like Loading...
