Tuesday, October 10, 2006

Randomizing rows

Select Top (@Top) from   order by checksum(newID())

NewID - generates unique identifier

Checksum() - converts the uniqe identifier to integer / hash value. 

0 Comments:

Post a Comment

<< Home