Random Number

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)

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:


Featured Articles

Learn Index Tuning!

Index Tuning Video Training
only $49
You'll learn everything practical there is to know about index tuning with this downloadable video.
Learn more

 Site Author

  • Thanks for visiting!