MSSQL(2)
-
전체 Database의 Stored Procedure 찾는 방법
전체 Database 내의 SP를 찾는 Query 입니다. EXEC sp_msforeachdb 'USE [?]; SELECT ''?'' ,name AS procedure_name ,SCHEMA_NAME(schema_id) AS schema_name ,type_desc ,create_date ,modify_date FROM sys.procedures; ' GO
2019.04.15 -
SQL Server에서 V$SQL 과 같이 최근 실행된 Query를 찾는 방법
SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query] 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
2016.06.23