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. This value is discontinued since GeneXus 17 Upgrade 11. It is only shown in a KB converted from an older version. Instead, you can use the value '2012 or higher'. |
| 2000 | The SQL Server version installed on the Server is 2000. This value is discontinued since GeneXus 17 Upgrade 10. It is shown only in a KB converted from an older version. |
| 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: SQL Server
This property 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 is that the temporary tables 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.
Notes:
- Since GeneXus 17 Upgrade 10, the SQL Server 2000 value has been discontinued. Read more at SAC #51285.
- Since GeneXus 17 Upgrade 11, the Azure value has been discontinued. Instead, you can use the value '2012 or higher' when generating for SQL Azure. Read more at SAC#51502.
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