How to get a list of Stored Procedures with Created Date and Modified Date in SQL Server
Introduction:
In this article i will explain how to get list of Stored Procedures with Created Date and Modified Date in SQL Server.
Description:
In previous articles i explained about joins, Batches, Stored procedure, Functions, Difference between Stored procedure and Function, and Triggers in SQL Server. Now i will explain how to get list of Stored Procedures with Created Date and Modified Date in SQL Server.
We can get list of stored procedure names with Created Date and Modified Date from particular database by using following ways:
Use Test
select name as [Procedure Name],
create_date as [Created Date],
modify_date as [Modified Date]
from sys.procedures
(or)
Use Test
select name as [Procedure Name],
create_date as [Created Date],
modify_date as [Modified Date]
from sys.objects
where type = 'P'
(or)
Use Test
select ROUTINE_NAME as [Procedure Name],
CREATED as [Created Date],
LAST_ALTERED as [Modified Date]
from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE = 'PROCEDURE'
Output:
-
CreatedJan 11, 2014
-
UpdatedOct 03, 2020
-
Views2,226
Related Articles
Different types of variables in SQL Server
What is Cross Join in SQL Server
How delete record from parent table when there is Foreign Key relation in SQL Server
What is the differences between CHAR, NCHAR, VARCHAR and NVARCHAR in SQL Server?
How to add or remove a column from a table in SQL Server?
How to insert values into Identity Column in SQL Server?
How to get a fixed-length value in SQL Server?
What is Left Join (or) Left Outer Join in SQL Server?
How to get current week dates in SQL Server?
What are the different types of Date formats in SQL Server?