提取找回未保存但运行过的SQL Query

如果不小心关闭了已经运行过但是没有保存的SQL Query Scripts，以下查询语句可以帮助提取所有已运行SQL Queries的历史记录。

Use Master 
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

 

资料源：https://stackoverflow.com/questions/15034832/recover-unsaved-sql-query-scripts/40558402