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

1 vote135 views2 answers
Mysql order by date asc null last
SQL
4 votes148 views1 answer
Group by mysql and concatenate string
SQL
1 vote148 views2 answers
Backup table mssql
SQL
6 votes185 views1 answer
Check Table Exists
SQL
1 vote146 views2 answers
Rebuild index sql server
SQL
0 vote150 views1 answer
Reset keys in sql
SQL
0 vote176 views1 answer
Get initials name in sql
SQL
150 votes329 views10 answers
Grepper
SQL
3 votes144 views4 answers
Truncate syntax in sql
SQL
-1 vote142 views1 answer
Sql syntax create timestamp column
SQL