Sql server 2012 query history

SELECT t.[text]
FROM sys.dm_exec_cached_plans AS p
CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t
WHERE t.[text] LIKE N'%something unique about your query%';

Source: stackoverflow.com

Similar codes

0 vote190 views1 answer
Mysql wsrep ls
SQL
-1 vote148 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote154 views1 answer
How to add boolean column in postgresql
SQL
1 vote140 views1 answer
Sql Split string function
SQL
0 vote146 views1 answer
Mysql update sum same table
SQL
0 vote159 views1 answer
What is mysql_pconnect
SQL
2 votes148 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
1 vote190 views2 answers
Intersect sql
SQL
0 vote135 views1 answer
Insert thai language sql server
SQL
0 vote181 views1 answer
Login failed for user sql server
SQL