The one of the most frequent asked question in database development is "How to filter the data returned by a query according to some user selected criteria?". To complete the solution with dynamic ordering see my other blog post.

For every method template I will add icons indicating corresponding advantages and drawbacks.

The rand() Transact SQL function produces a sequence of same numbers in the query. For example:

ADO SQL Tool for developing and debugging SQL-scripts and queries to MS Access and other databases. Main features:

Need to manage your website's contents?

• Do you need to manage your website's contents, but you wouldn't like to install and support some contents management system (CMS)?
• Do you want to develop your website's design separately from its contents?
• Do you prefer to use open standards and technologies like XML and XSLT?

OffSite Builder will help you.