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
Posted by Mohit 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Sql Server
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Index

  • ►  2017 (1)
    • ►  February (1)
  • ►  2016 (1)
    • ►  February (1)
  • ►  2014 (2)
    • ►  March (2)
  • ►  2013 (1)
    • ►  January (1)
  • ►  2012 (3)
    • ►  December (1)
    • ►  October (1)
    • ►  February (1)
  • ►  2011 (1)
    • ►  March (1)
  • ►  2010 (4)
    • ►  May (2)
    • ►  March (2)
  • ►  2009 (22)
    • ►  November (1)
    • ►  October (6)
    • ►  August (3)
    • ►  July (2)
    • ►  June (3)
    • ►  May (3)
    • ►  March (4)
  • ▼  2008 (17)
    • ►  December (1)
    • ►  September (1)
    • ▼  August (1)
      • Display Random value in Sql server 2000
    • ►  April (2)
    • ►  February (12)
Mohit
View my complete profile

Blogs

  • AngularJS
  • Asp.net
  • Vb.net Link
  • Obect Oriented Programming
Ethereal theme. Powered by Blogger.