SQL Reference(reserved keyword)
SQL Server 2008: Oracle 10g release 2 MySQL 5.0 DB2 V9.7 Microsoft Office Access
Category reference
sql reference
Datatypes translation between Oracle and SQL Server part 1: character, binary strings
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…
Correlation names and Column name qualifiers in correlated references
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…
How to find out datbase version using SQL query
DB2 SELECT versionnumber, version_timestamp, Substr(authid, 1, 20) FROM sysibm.sysversions MySQL SELECT Version(); SQL SERVER SELECT @@VERSION Oracle SELECT * FROM v$version;
SQL Language elements (characters)
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…