Select random rows from a MS-SQL Server table

SELECT TOP 1 *
FROM TABLE_NAME
ORDER BY NEWID()