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 an Azure SQL Database or an Azure SQL Managed Instance |
| 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. |
Available at the Data Store.
Data Store: SQLSERVER
Note: Since Genexus 17 update 11, the Azure value is discontinued. Instead, you can use the value 2012 or higher when generating for SQL Azure. Read more:
SAC#51502.
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.).
When the SQL Server version Azure is selected, the code is generated as if SQL Server 2012 or higher is selected. The exception to this is, that the temporary tables that are created during the reorganization process are created with a clustered index given related restrictions of SQL Azure.
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 the corresponding changes when the property value is configured, execute a Rebuild All.
Lock time-out (seconds) property
Oracle version property
Informix Version property
MySQL version property
DB2 UDB Version property
Azure SQL