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

4 votes188 views3 answers
Sql find second highest salary employee
SQL
0 vote179 views1 answer
Lister les index d'une table oracle
SQL
3 votes198 views4 answers
Show databases in sql server
SQL
2 votes192 views1 answer
Sql as
SQL
6 votes206 views1 answer
Postgres get size of database
SQL
3 votes203 views1 answer
Increment integer in table sql
SQL
2 votes237 views1 answer
Revokeprivileges mysql
SQL
0 vote284 views2 answers
Search stored procedures by name
SQL
0 vote211 views3 answers
Run sql command line
SQL
0 vote199 views1 answer
Sql get number of days between two dates
SQL