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 vote136 views1 answer
Mysql uuid
SQL
3 votes150 views2 answers
How to force truncate a table in mysql
SQL
0 vote131 views1 answer
Replace multiple string in query sql
SQL
0 vote137 views1 answer
Alasql delete column
SQL
2 votes130 views1 answer
Sql like variable
SQL
3 votes135 views3 answers
Into in sql
SQL
0 vote137 views1 answer
Mysql 1 hour ago
SQL
1 vote152 views1 answer
Mysql show database size in mb
SQL
0 vote176 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
3 votes137 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL