SQL Server Transact Basic to Expert - Display the Year integer value using systemdate

This blog shows how to do an get the Years integer value alone from the Systemdate in the output using SQL Query Example: SELECT YEAR(GETDATE()) The expected result would be 2011