Skip to content
«
»
 

Random Number

Posted by 
on  November 23 2009

The following SQL script will generate a single random number:

SELECT CAST(1000000-CEILING(RAND()* 899001) + (DATEPART(ss, GETDATE()) * 1000 ) + DATEPART(ms, GETDATE()) as int)


Popular search terms:
Filed under SQL
Comment (RSS)  |  Trackback  |  Permalink

2 Comments

  1. Anonymous says:
    November 27, 2010 at 4:01 am

    how to count hours based on date

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»