sys.dm_os_windows_info

Returns one row that displays Windows operating system version information.

SELECT * FROM sys.dm_os_windows_info

http://technet.microsoft.com/en-us/library/hh204565.aspx

Note: Available from MSSQL 2008 R2 SP1.