Mohit Agrawal
Success is Journey it's not a destination
Menu
Home
Sql server 2008
Differences
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
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)