1. Wendy elizabeth New Member

   I would like to know how to select random records from data in both sql server 2005 standard edition and sql server 2008 r2 using t-sql.

   Wendy elizabeth, May 27, 2011

   #1
2. Luis Martin Moderator

   Check:
   TABLESAMPLE
   in BOL

   Luis Martin, May 27, 2011

   #2
3. FrankKalis Moderator

   In addition to Luis, you might want to see if this helps: Selecting Rows Randomly from a Large Table.

   FrankKalis, May 31, 2011

   #3
4. SQL Server Helper New Member

   Here's another link that may be helpful: http://www.sql-server-helper.com/tips/generate-random-records.aspx
   
   Regards,
   SQL Server Helper

   SQL Server Helper, Jul 6, 2011

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in