SQL server version property

Official Content
This documentation is valid for:
Indicates which SQL Server version is installed on the Database Server.

Values

2012 or higher The SQL Server version installed on the Server is 2012 or higher.
Azure The SQL Server is hosted in the Microsoft cloud site.
2000 The SQL Server version installed on the Server is 2000.
2005 to 2008 R2 The SQL Server version installed on the Server is between 2005 and 2008 R2.

Description

It is used, for example, to determine the syntax for OUTER JOINs and for table creation/reorganizations (i.e., the 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.

Run-time/Design-time

This property applies only at design-time.

How to apply changes

To apply changes made by this property, do a Re-Build All.

Scope

Available at the Data Store.
Data Store: SQLSERVER

See Also

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