K'Blog

Because there’s always more to learn

  Home  |   Contact  |   Syndication    |   Login
  10 Posts | 0 Stories | 2 Comments | 0 Trackbacks

News

Twitter












Archives

Post Categories

ASP.NET

September 2008 Entries

Recently, in one project i need to get random records from sql server table and i found a good way to do that. SELECT TOP <n> <column list> FROM <table> WHERE <criteria> ORDER BY NEWID()The main function is NEWID() which return GUID.Cheers !!Krunal
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Hello all, This is my first post on geekswithblogs.net I m so excited about this. I'll update and share the best things in technology, that i can. Thanks, Krunal Mevada
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati