December 9, 2014 at 9:15 am
Comments posted to this topic are about the item All OS version in one function
Wilfred
The best things in life are the simple things
December 29, 2014 at 3:29 am
Hi Wilfred, there is a small typo in the code; in the select ... full_windows_name from ... cte one quote ( ' ) is used instead of two ( ' ' ).
cheers Leon
December 29, 2014 at 8:12 am
Very nice script. As noted in the above post, the last few lines should read:
then windows_server_release_name + rtrim(' ' + windows_service_pack_level) + ' ' + case when left(windows_server_release_name, len(windows_product_type)) <> windows_product_type then windows_product_type else ' ' end
else windows_home_release_name + rtrim(' ' + windows_service_pack_level) + ' ' + case when left(windows_home_release_name, len(windows_product_type)) <> windows_product_type then windows_product_type else ' ' end
end as full_windows_name
fromCTE
)
go
Thanks again, this will be very useful.
Jeff Bennett
St. Louis, MO, USA
December 29, 2014 at 11:31 am
I already noticed the missing quote and fixed the code. However, the SQLServerCentral team first reviews every change before it's published so there's a slight delay before it's available. The correct version should be available now for download.
Wilfred
The best things in life are the simple things
December 30, 2014 at 12:48 am
NOTE: This function works with SQL2008R2 SP1 and upwards. So if you're still having an RTM version, it's time to update! :hehe:
Wilfred
The best things in life are the simple things
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy