The easiest way to get SQL version

Most of people suggest to use “@@VERSION” and “SERVERPROPERTY”

But when we manage SQL server, DBA or developer need to do a lots tedious/repeatable tasks to determine the SQL version in order to meet different needs. So the method above is not what I need.

The most convenient way and the easiest way to remember the syntax is

SELECT @@VERSION<br /><br />

It shows not only the detail SQL version but also the Windows version

But you have to do lots “STRING” function if you want to manipulate the info for program purpose


So there are lots SQL professionals contributed lots syntax to help us such like

SELECT Left(@@Version, Charindex('-', @@version) - 2) [Version],SERVERPROPERTY('productversion'),SERVERPROPERTY ('edition')<br />

or

SELECT LEFT(CONVERT(CHAR(2),SERVERPROPERTY('ProductVersion')), 2) <br />

or

SELECT SERVERPROPERTY('ProductVersion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')<br />

But But, they are not really very easy to get the version number.

So I mine more and find out the easiest way to do it and it’s been existed in database already. The syntax is @@microsoftversion, I don’t have time to talk about more with it, just give you the code I used, if you have time, you can always contribute good articles to me.

SELECT<br />(@@microsoftversion / 0x1000000) & 0xff AS [VersionMajor],<br />(@@microsoftversion / 0x10000) & 0xff AS [VersionMinor],<br />@@microsoftversion & 0xffff AS [BuildNumber]<br />