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 vote183 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote188 views1 answer
Insert set mysql
SQL
9 votes233 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote213 views1 answer
Dual in db2
SQL
2 votes192 views1 answer
How to check if a row is null in sql
SQL
3 votes247 views2 answers
Update part of a string in mysql
SQL
0 vote195 views1 answer
Mysql_num_fields in mysqli
SQL
1 vote237 views2 answers
Select into temp table
SQL
1 vote223 views1 answer
Postgresql not in
SQL
0 vote202 views1 answer
Mssql dockere
SQL