Can t-sql generate random numbers

Question

I want to generate a set of 10 random numbers
does sql server have a method for this?

Answer 1

Hi @Marksdasjkv ,

Please try this query:

;with LoopCounter  
    as(  
        select 1 Indexer,  ABS(Cast(Cast(CRYPT_GEN_RANDOM(4) as INT) as Float)) / Cast(0x7FFFFFFF as int) RandNumber  
        union  all  
        select Indexer + 1,  ABS(Cast(Cast(CRYPT_GEN_RANDOM(4) as INT) as Float)) / Cast(0x7FFFFFFF as int)  RandNumber  
        from LoopCounter  
        where   
          Indexer < 10  
      )  
    select *  
    from LoopCounter    
    

Best regards
Niko

----------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Check the RAND function: https://learn.microsoft.com/en-us/sql/t-sql/functions/rand-transact-sql.

Show details if you need something special.