Select random records

1 Kicks

submitted by aspcode.net(1045) 5 years ago

This SQLServer tip shows how (from a single stored procedure) select X (parameter) number of random records.

1 comment |category: Database |Views: 17
Tweet

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

Comments:

posted by rimsystems(6119) 5 years ago 0

Old standby tip that works great for small result sets. Don't even bother trying it on large tables (>100K rows)

What's this?