Get last run query sql server

Sql server last executed query

SELECT deqs.last_execution_time AS [Time], dest.text AS [Query], dest.*
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE dest.dbid = DB_ID('msdb')
ORDER BY deqs.last_execution_time DESC

SELECT dest.TEXT AS [Query],
deqs.execution_count [Count],
deqs.last_execution_time AS [Time]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
ORDER BY deqs.last_execution_time DESC

Source: grepper.com

Similar codes

2 votes119 views1 answer
Sql string_agg
SQL
0 vote135 views1 answer
Mysl like insert a variable
SQL
1 vote106 views1 answer
Sql to mongodb query converter
SQL
0 vote146 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
16 votes100 views4 answers
Mysql import from sql file
SQL
0 vote108 views1 answer
Plsql check for string in numeric
SQL
0 vote103 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote106 views1 answer
View to table
SQL
2 votes131 views1 answer
Python sql
SQL
0 vote92 views1 answer
Sql get month and year from date
SQL