7/30/2018 0 Comments Sql Server Version download@@Version - Transact SQL Configuration Functions • • 2 minutes to read • Contributors • • • • • • In this article THIS TOPIC APPLIES TO: SQL Server (starting with 2008) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse Returns system and build information for the current installation of SQL Server. Syntax @@VERSION Return Types nvarchar Remarks The @@VERSION results are presented as one nvarchar string. You can use the function to retrieve the individual property values. For SQL Server, the following information is returned. • SQL Server version • Processor architecture • SQL Server build date • Copyright statement • SQL Server edition • Operating system version For Azure SQL Database, the following information is returned. • Edition- 'Microsoft SQL Azure' • Product level- '(RTM)' • Product version • Build date • Copyright statement. Note We are aware of an issue where the product version reported by @@VERSION is incorrect for Azure SQL Database. The version of the SQL Server database engine run by Azure SQL Database is always ahead of the on-premises version of SQL Server, and includes the latest security fixes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |