/* MySQL */
SELECT VERSION();
/* Firebird */
SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database;
/* PostgreSQL */
SELECT version();
/* SQL Server */
SELECT CAST(SERVERPROPERTY('productversion') AS VARCHAR(30));
/* SQL AnyWhere */
SELECT TOP 1 version
FROM SYSHISTORY
WHERE operation = 'START'
ORDER BY first_time_utc DESC;
/* sqlite */
select sqlite_version();
/* Oracle */
select * from v$version WHERE ROWNUM = 1;
|
|
|
|
|
|
|