Indicates which SQL Server version is installed on the Database Server.
|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.|
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.
This property applies only at design-time.
To apply changes made by this property, do a Re-Build All.
Available at the Data Store.
Data Store: SQLSERVER
Lock time-out (seconds) property
Oracle version property
Informix Version property
MySQL version property
DB2 UDB Version property