We often need to limit the number of rows returned by a select statement. Some database servers provide extensions to the select statement. For example, MySql database sever provides LIMIT directive. In Oracle Database each result set has defined a ROWNUM pseudocolumn and ORDER BY clause interact. Read the rest of this entry »
You can easily split long command line into multiple lines. Read the rest of this entry »
bb: Usage Stats collects information about page, post, category and homepage views for your WordPress blog. Builds daily and monthly usage statistics. Read the rest of this entry »
The bb:Text Rotator WordPress plugin contains bb:Text Rotator Widget.
As any WordPress widget, you can add the bb:Text Rotator Widget to any sidebar using the WordPress administrative interface (Appearance – Widgets menu). From the Widget administration form you can define text snippets. You can specify as many text snippets as you like.
When WordPress builds the output HTML, the widget randomly selects a snippet and inserts it in place of the widget.
Any widget have a priority. The higher is the priority of the snippet, the higher is the chance that it will be selected for display.
Current Stable Version: [TODO] [Download]
Previous Versions: [TODO]
Data expressions can be used to describe structure of data. Read the rest of this entry »
This tutorial shows how to select random row from IBM DB2 table. Read the rest of this entry »
Here is a SQL query that selects a random row from a Microsoft SQL Server table. Read the rest of this entry »
The following tutorial shows how to retrieve random record from MySQL database table. Read the rest of this entry »
Shortcodes are very effective way to include dynamic content into your posting. This tutorial will guide you through the process of creating your own shortcode. Just in few easy steps. Read the rest of this entry »
You can use the following SQL to select random record from a PostreSQL table. Read the rest of this entry »
