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

10 votes55 views1 answer
Oracle all_dependencies
SQL
0 vote88 views1 answer
Multiple row join
SQL
2 votes54 views1 answer
Mysql select random id from table
SQL
2 votes52 views1 answer
Oracle table size
SQL
0 vote58 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote57 views1 answer
Sql delete caracter list
SQL
0 vote59 views1 answer
Postgresql where clause not working
SQL
1 vote62 views1 answer
Sql select whole row max column
SQL
0 vote56 views1 answer
Nuget sqllite-net-pcl
SQL
2 votes43 views1 answer
Sql find missing values between two tables
SQL