Recover text of recently executed query

I thought I had saved the stored procedure, but when I searched, I could not find it. Fortunately, this script can solve this problem:

Use <DataBaseName>

SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery

CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql

ORDER BY execquery.last_execution_time DESC

Very Handy!!!