Select random rows from a MS-SQL Server table

SELECT TOP 1 *
FROM TABLE_NAME
ORDER BY NEWID()

Select Only Year of Datetime MSSQL

SELECT DISTINCT CONVERT(CHAR(4), @DatetimeValue, 120) as Year

FROM Events

Select Only Month of Datetime MSSQL

SELECT DISTINCT CONVERT(CHAR(3),@DatetimeValue, 100) as MONTH

FROM Events