August 23, 2008

Display Random value in Sql server 2000

NEWID() function also generates random value in table.
Example:
SELECT id, name FROM myTable order by NewID()
Output
------------
id  Name
6  abc
3  abc1
7  cba
1  xyz
10  aaaa
12  zzzz

1 comment: