all about SQL
People always post SQL code into blogs and forums need a tool to help them to prepare dull monochrome, badly-formatted SQL code for HTML-based publication in a nice clean style. SQL Pretty Printer is able to output HTML in both…
When format SQL query, capitalization refers to the way in which SQL token should or should not be capitalized in your code. For example, some developers prefer to make all reserved keys uppercase, others prefer lowercase, and some mix and…
Here are some SQL programming guidelines and best practices we collected, keeping quality, performance and maintainability in mind. This list is not complete at this moment, and will be constantly updated. Do not use SELECT * in your queries. Always…
SQL Server 2008: Oracle 10g release 2 MySQL 5.0 DB2 V9.7 Microsoft Office Access
This is an article in the series that we talking about translate SQL query among different databases. This article focus on the translation of number datatype between oracle and SQL Server database. The main difference of number datatype between oracle…
Datatypes translation is one of the most important things you need to consider when migrate your application from one database to the other. This is one of the series of articles that we talking about translate SQL query among different…
A correlation name can be defined in the from clause of a query and in the first clause of an update or delete statement. for example, the clause FROM X.MYTABLE Z establishes Z as a correlation name for X.MYTABLE. With…
DB2 SELECT versionnumber, version_timestamp, Substr(authid, 1, 20) FROM sysibm.sysversions MySQL SELECT Version(); SQL SERVER SELECT @@VERSION Oracle SELECT * FROM v$version;
characters, the basic symbols of keywords and operators in SQL language are the single-byte characters that are part of all IBM character sets. charaters of language are classified as letters, digits or special characters. A letter is any of the…
