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

1 vote125 views1 answer
Mysql history command
SQL
-1 vote119 views1 answer
Add column alter table default value
SQL
1 vote113 views1 answer
Tsql random number
SQL
0 vote130 views1 answer
Sql drop default
SQL
0 vote138 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
1 vote120 views1 answer
Mysql batch insert
SQL
0 vote142 views1 answer
Mysql conf.d exampel
SQL
-1 vote81 views1 answer
How to create script to connect to oracle database and run query
SQL
2 votes138 views2 answers
Mysql limit
SQL
1 vote125 views1 answer
How much every mysql database record takes from diskspace
SQL