Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# Category reference

sql reference

- reference, sql

## SQL Reference(reserved keyword)

SQL Server 2008: Oracle 10g release 2 MySQL 5.0 DB2 V9.7 Microsoft Office Access

- admin
- November 14, 2010

- reference, sql, translation

## 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…

- admin
- July 28, 2010

- reference, sql

## 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…

- admin
- December 17, 2009

- reference, sql

## 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;

- admin
- December 10, 2009

- reference, sql

## 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…

- James
- December 6, 2009