Scope

DBMS: SQL Server

Purpose:

Tells GeneXus what SQL Server version is installed on the Database Server.

Values

2000: The SQL Server version installed on the Server is 2000
2005 or higher: The SQL Server version installed on the Server is 2005 or higher

Default Value = 2005 or higher⁽¹⁾

⁽¹⁾ SQL Server 2008 R2 is supported as from GeneXus X.

Description

It is used for example to determine the syntax for OUTER JOINs and for table creation/reorganizations (i.e. syntax of CREATE TABLE, CREATE INDEX, etc.).

Every new version of the DBMS has new features that are used by GeneXus, which generates different SQL sentences or considers properties that can be applied to the new version.

See Also

Lock Time-out (seconds) Property
Oracle Version Property
Informix Version Property
MySQL Version Property
DB2 UDB Version Property?