Sothink DHTML Menu 8

– Easy Builder to Create JavaScript Cross Browser Menus!

Sothink DHTML Menu is a comprehensive navigation solution for web site. It creates drop-down menu easily and behaves friendly to search engine. Includes user-friendly interface, keyboard navigation, fresh templates, lots of effects and optimal publishing. Tree-like menu can be switched to drop-down menu. Copy and paste menu items in different menu files. Supports Windows Vista. Free add-ins for Dreamweaver, FrontPage, Expression Web and GoLive.

Version 8.2 supports Keyboard Navigation function, which enables user to control the menu by using the keyboard; adds advanced function to both Menu Item Setting and Separator Setting.

(more…)

/*
mysql> select CONCAT(“a”,”B”);
+—————–+
| CONCAT(“a”,”B”) |
+—————–+
| aB |
+—————–+
1 row in set (0.00 sec)

*/
select CONCAT(“a”,”B”);

You can use this concat in any kind of SQL command! All depends upon your creativity. For example I had a country names database with a column for flag icons which I thoughtI would insert later on. It was empty for long time and only countries names were in it. So I got the country flag icons from a friend. Just put them in a folder and used concat for concatenating (joining) the names of the country names with a ‘.gif’ to generate the flag icons’ names! Used them in the update query and it worked. Saved me hours of data entry!

Migrate Microsoft SQL Server Transact-SQL to Oracle PL/SQL

SwisSQL – SQL Server to Oracle Migration Tool helps you migrate MS SQL Server Transact-SQL Procedures, Functions and Triggers to Oracle PL/SQL language. When enterprises migrate from MS SQL Server to Oracle, application migration is one of the tedious tasks and there are no good tools which can ease the process of migrating MS SQL Server Stored Procedures to Oracle PL/SQL. Using SwisSQL – SQL Server to Oracle Migration Tool and through AdventNet’s superior support, enterprises can realize significant time and cost savings during the migration and testing process.

For more information on this tool, go to this page. 

As I am working on a project where ordering by the average value of a related record in a subtable is needed so I googled for ‘SQL sorting by a field’s average’ and found this useful link