skip to main | skip to sidebar

Microsoft CRM Hacks

First of all, the primary objective of this blog is for my own reference, as I am a very forgetful person, so, I need a way to document all findings, tips and tricks somewhere, which allows me access anytime anywhere. If you find any stuff here useful, you can go ahead and utilize it, and you are welcome to post your ideas and suggestions, I will be well appreciated them. But I will not answer to any queries regarding further elaboration on the topic I documented here.

Tuesday, October 24, 2006

SQL: Select a random record

Selecting a random record from Table/View. Assuming the table name is Contact:

   SELECT TOP 1 * FROM Contact ORDER BY NEWID()
   GO


Posted by yamato at 12:26 PM No comments:
Labels: SQL
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Search

Labels

  • MSCRM4 Client (4)
  • MSCRM4 Configuration (2)
  • MSCRM4 Diagnostic (3)
  • MSCRM4 Email (2)
  • MSCRM4 Plug-in (2)
  • MSCRM4 Workflow (1)
  • SQL (2)
  • SQL Server (1)
  • Web Service (1)
  • Z. MSCRM3 Client (1)
  • Z. MSCRM3 SDK (1)

Blog Archive

  • ►  2009 (2)
    • ►  January (2)
  • ►  2008 (13)
    • ►  September (1)
    • ►  July (1)
    • ►  June (2)
    • ►  May (1)
    • ►  April (2)
    • ►  March (1)
    • ►  February (3)
    • ►  January (2)
  • ►  2007 (1)
    • ►  January (1)
  • ▼  2006 (4)
    • ▼  October (1)
      • SQL: Select a random record
    • ►  September (1)
    • ►  August (1)
    • ►  July (1)
  • Microsoft Dynamics CRM Team Blog