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 vote330 views1 answer
How to find median of a column sql
SQL
0 vote348 views1 answer
Xamarin sql lite create table if not exist
SQL
2 votes337 views1 answer
Mysql Incorrect column specifier for column
SQL
11 votes359 views4 answers
MYSQL LOGIN
SQL
1 vote317 views1 answer
Sql week commencing date
SQL
2 votes353 views1 answer
Mariadb json select
SQL
0 vote346 views1 answer
Mysql multiple primary keys
SQL
1 vote321 views1 answer
Sql select where id not exists in another table
SQL
9 votes316 views2 answers
Default number in sql
SQL
0 vote391 views1 answer
Sql to excel pgadmin
SQL