|
|
|
Click here to copy the following block |
SET ROWCOUNT 5; SELECT O.OrderID , o.CustomerID , RAND( ( @@IDLE % O.IDENTITYCOL ) + DATEPART( ms , CURRENT_TIMESTAMP ) + O.IDENTITYCOL ) AS RandVal FROM Northwind..Orders AS O ORDER BY RandVal;
SELECT TOP 5 O.OrderID , o.CustomerID , RAND( ( @@IDLE % O.IDENTITYCOL ) + DATEPART( ms , CURRENT_TIMESTAMP ) + O.IDENTITYCOL ) AS RandVal FROM Northwind..Orders AS O ORDER BY RandVal;
SET ROWCOUNT 5; SELECT O.OrderID , o.CustomerID FROM Northwind..Orders AS O ORDER BY RAND( ( @@IDLE % O.IDENTITYCOL ) + DATEPART( ms , CURRENT_TIMESTAMP ) + O.IDENTITYCOL ); |
|
|
|
Submitted By :
Nayan Patel
(Member Since : 5/26/2004 12:23:06 PM)
|
|
|
Job Description :
He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |
View all (893) submissions by this author
(Birth Date : 7/14/1981 ) |
|
|