commands for viewing version information

Original: command to view version information

This article contains the commands for viewing the software version information in my work:

Operating system:

Windows : Open the command line →systeminfo >xx.txt, you can output the Windows information into the Xx.txt file. This can be used to view information such as the number of bits of the operating system.

Ubuntu: sudo lsb_release-a

Software:

SQL Server: Open ssms→

SELECT @ @version

or execute:can view the version of SQL Server and even more detailed information.

xp_msver

Execute system Stored procedure: also can obtain information. However, the stored procedure may not be available for later versions

Sp_msgetversion

Execute statement: The same information can be obtained.

SELECT serverproperty (' productversion '), serverproperty (' ProductLevel '), Serverproperty (' edition ')

Since I am using the R2, only the version number of this version is listed:

10.50.1600.1 SQL Server R2 RTM

10.50.1702.0 SQL Server R2 RTM cumulative Update 1

10.50.1720.0 SQL Server R2 RTM cumulative Update 2

10.50.1734.0 SQL Server R2 RTM cumulative Update 3

10.50.1746.0 SQL Server R2 RTM cumulative Update 4

10.50.1753.0 SQL Server R2 RTM cumulative Update 5

10.50.1765.0 SQL Server R2 RTM cumulative Update 6

10.50.1777.0 SQL Server R2 RTM cumulative Update 7

10.50.1797.0 SQL Server R2 RTM cumulative Update 8

10.50.2500.0 SQL Server R2 SP1

10.50.2769.0 SQL Server R2 SP1 cumulative Update 1

Python:

Import Syssys.version

commands for viewing version information