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 vote176 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote144 views1 answer
Mysql jdbc timezone
SQL
6 votes175 views2 answers
How to get yesterday date in mysql
SQL
0 vote129 views2 answers
Android sqlite query join
SQL
2 votes148 views1 answer
Mariadb JSON_EXTRACT
SQL
1 vote158 views1 answer
Raw query must include primary key
SQL
0 vote163 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote140 views1 answer
Sqlite3 now
SQL
1 vote154 views2 answers
Postgresql backup and restore globals and data
SQL
4 votes141 views3 answers
Create database in mySQL
SQL