不同的数据库系统方法不一样。
ms sql server: SELECT @@VERSION AS 'SQL Server Version';
oracle: SELECT * FROM v$version WHERE banner LIKE 'Oracle%';
db2: SELECT * FROM SYSIBM.SYSVERSIONS;
infomix: SELECT DBINFO('version', 'major') FROM systables WHERE tabid = 1;
select @@VERSION, SERVERPROPERTY('ProductVersion') AS ProductVersion
, SERVERPROPERTY('ProductLevel') AS ProductLevel, SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('EngineEdition') AS EngineEdition