How to use parsename with SERVERPROPERTY(‘productversion’)

(Jack Vamvas) Question: I’d like to use SERVERPROPERTY(‘productversion’) for purposes of reporting on current sql server level. I’m using the SERVERPROPERTY(‘productversion’) funcion, but am struggling with how to split the parts of the details, to make it easier for reporting.

Register to Read