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

0 vote221 views1 answer
Postgresql on conflict pair
SQL
1 vote202 views1 answer
Mysql show current queries
SQL
5 votes220 views2 answers
Mysql dump mysql db cli
SQL
3 votes214 views3 answers
Create table in microsoft sql server
SQL
0 vote210 views1 answer
Into operator in sql
SQL
0 vote220 views1 answer
Min varias colunas spark sql
SQL
1 vote191 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote188 views1 answer
Mysql milliseconds
SQL
0 vote178 views1 answer
Power query case when
SQL
7 votes186 views2 answers
MySQL IF without else
SQL