Quảng Cáo

Cpm Affiliation : the cpm advertising network

SQL SERVER – Find Stored Procedure Create Date and Modified Date

Category: , Written by Nam Phạm Ngọc Quang / 10:53
SQL SERVER – Find Stored Procedure Create Date and Modified Date


This post demonstrates the script which displays create date and modify date for any specific stored procedure in SQL Server.
USE AdventureWorks;
GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'uspUpdateEmployeeHireInfo'
GO
Thank for sharing!

About The Author


NamPNQ

Không biết viết gì ở đây :D

Quảng cáo