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
1 comment:
Soumitra Bhatt
September 29, 2008 at 2:45 PM
This comment has been removed by a blog administrator.
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
This comment has been removed by a blog administrator.
ReplyDelete