Random Number

The following SQL script will generate a single random number:
[cc lang=”sql”]
SELECT CAST(1000000-CEILING(RAND()* 899001) + (DATEPART(ss, GETDATE()) * 1000 ) + DATEPART(ms, GETDATE()) as int)
[/cc]

3 comments
Anonymous 27 Nov 2010 at 4:01 am

how to count hours based on date

Derek Dieter 27 Nov 2010 at 8:19 am

hi, to do this use:

Datediff(hh,date1,date2)

Steven 29 Aug 2015 at 7:02 am

Thanks Michelle!! I was quite happy with the turnout and meteing in general so hopefully EDMPASS can keep up the momentum and get 30 people next monthIn looking at the 380PASS website I see you have Steve Wright presenting I’m going to be having Steve do the same presentaiton in an upcoming meteing. Be sure to let me know how it goesThanks again!!

Featured Articles

 Site Author

  • Thanks for visiting!
css.php