SQL SERVER: Clear single use plans from cache

ClearSingleUsePlansFromCache.sql

DECLARE @Sql VARCHAR(MAX) = (
	SELECT 'DBCC FREEPROCCACHE (0x' + CONVERT( VARCHAR(MAX), [ecp].[plan_handle], 2) + ') WITH NO_INFOMSGS; ' + CHAR(10)
	FROM   [sys].[dm_exec_cached_plans] [ecp]
	WHERE  [ecp].[usecounts] = 1
			AND [ecp].[objtype] IN('Adhoc', 'Prepared')
	FOR XML PATH('')
);

SELECT @sql
--EXEC (@sql)