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

10 votes228 views2 answers
Linux command line import mysql database
SQL
7 votes231 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
-1 vote232 views1 answer
Adding a new table psql
SQL
1 vote255 views1 answer
Sql server delete top 1000
SQL
0 vote234 views2 answers
Postgres having
SQL
0 vote238 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote442 views1 answer
Power bi connect to postgresql
SQL
2 votes230 views1 answer
Sql column values comma separated
SQL
0 vote225 views1 answer
Varchar format not case sensitive sql
SQL
0 vote226 views1 answer
Cast float mysql
SQL