Random Number

Posted on November 23, 2009 by Derek Dieter
2
0

« Simplifying Security Using Schemas

Create Index on Temp Table »

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)

Post a comment

2 comments

Anonymous 27 Nov 2010 at 4:01 am

how to count hours based on date

Reply to this comment

Derek Dieter 27 Nov 2010 at 8:19 am

hi, to do this use:

Datediff(hh,date1,date2)

Reply to this comment

Featured Articles

SQL Server Database Optimization Guide In the troubleshooting guide we went over the different physical bottlenecks that can
Yet Another Temp Tables Vs Table Variables Article The debate whether to use temp tables or table variables is an old
Using Union Instead of OR Sometimes slow queries can be rectified by changing the query around a bit.
User Defined Functions and Performance There is definitely a lack of awareness in the SQL world regarding the

Site Author

Resources