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 vote230 views1 answer
Python mysql query to dataframe
SQL
7 votes292 views2 answers
3rd height salary sql
SQL
6 votes223 views1 answer
Oracle list primary key
SQL
0 vote219 views1 answer
Import big data to mysql
SQL
3 votes228 views1 answer
Where id is in list sql
SQL
0 vote228 views1 answer
Sql alter table add column if exists
SQL
6 votes253 views2 answers
Install psql mac
SQL
1 vote226 views1 answer
Pl sql ptint
SQL
0 vote195 views1 answer
Mysql does collate nopad recognize space
SQL
3 votes222 views2 answers
MySQL query to get column names
SQL