SQLproNews Home Page About Article Archive News Downloads WebProWorld Forums Jayde iEntry Advertise Contact


Click to Play

Recent Google Announcements...
It is always interesting to find out what search industry veteran Danny Sullivan has to say about announcements pertaining to the Web. For this reason, WebProNews...

Recent Articles

Teradata Releases New Database Features
Todd Walters introduced the new release - 13.10. Not every feature is equally interesting to me but a couple were important to note: One of the key features in the new database release is the support for...

MySQL Incremental Backup
Best practices encourage SQL administrators to have a system in place to automatically and routinely backup their database. Let's take a look at a line of Joe Sysop's crontab file: 30 15 * * 3,5 mysqldump --user...

Using MySQL Workbench To Copy/View/Edit...
This guide is designed to be used for Linux desktops and servers. For best results, use the same Linux version for the desktop as is installed on...

06.08.10



A Uniform Query To The Community

By Michael Marr

The language of SQL is a lot like the English language. You have North American and Great Britain dialects of the language, not to mention significantly varying degrees of those dialects broken down amongst the geographical regions in which they're spoken.

And so is the fate of the Structured Query Language. Although the base of the language remains somewhat intact, programming in Oracle, Microsoft SQL, PostgreSQL, or other SQL extensions when you're from a MySQL background becomes painfully difficult at times (or switch MySQL with any of the other languages and the same occurs). The line between proper SQL and the corner of the SQL world we belong to become blurred, and only when we are forced to use another SQL environment are we painfully reminded of this.


The solution? A community project to convert SQL from one extension to the another. This way, when someone gets a project requiring them to use a foreign SQL engine, they can proudly take on the project, writing it in their own version of SQL first, and then convert using this magic tool. Does this project already exist? Not that I could find. If so, please let me know so I can update this article. Why can't I start it? I could, and probably will. What I'll need though is help, in more ways than just this project, but we'll concentrate on the project for now. I am proficient with MySQL (and now familiar with T-SQL thanks to a recent project), but hardly have the capacity to relate the nuances of other languages, e.g. converting MySQL's LIMIT to TOP.

So my fellow SQL Professionals, let us unite! No longer shall we be afraid to venture into Oracle, PostgreSQL, MySQL, or whatever other SQL language the world throws at us, but rather, let us be properly equipped to take on whatever challenges we are given!


About the Author:
Michael Marr is a IT staff Writer for WebProNews.

SQLproNews is brought to you by:

SecurityConfig.com NetworkingFiles.com
NetworkNewz.com WebProASP.com
DatabaseProNews.com SQLProNews.com
ITcertificationNews.com SysAdminNews.com
SQLproNews.com WirelessProNews.com
CProgrammingTrends.com SysAdminNews.com


About SQLproNews
SQLproNews is a collection of up to date tutorials and insightful articles designed to help SQL users of any skill level implement successful SQL systems and practices. SQL Strategies and Tactics for Business




-- SQLProNews is an iEntry, Inc. publication --
iEntry, Inc. 2549 Richmond Rd. Lexington KY, 40509
2010 iEntry, Inc.  All Rights Reserved  Privacy Policy  Legal

advertising info | news headlines | free newsletters | comments/feedback | submit article


SQL Strategies and Tactics for Business SQLproNews News Archives About Us Feedback