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 vote273 views1 answer
Output table plsql
SQL
5 votes293 views2 answers
Sql number columns
SQL
31 votes263 views3 answers
Sql count
SQL
1 vote232 views1 answer
Postgres kill pid
SQL
5 votes259 views2 answers
Oracle to_timestamp
SQL
1 vote271 views1 answer
Mysql select update same table
SQL
0 vote269 views1 answer
Sql server inner join convert collation
SQL
0 vote282 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote287 views2 answers
Oracle sql for each row
SQL
1 vote277 views2 answers
Mysql show views
SQL