Saturday, July 20, 2013

SQL Server -List of Procedure modified / created within specified date

Below is the SQL query which we can use to find out if any procedure has been modified recently in last 7 days or if any procedure has been created in last 7 days

Modified Procedure
use Northwind
select name
from sys.objects
where type='P' and DATEDIFF(D,modify_date,GETDATE())<7

Below is the result you would see





Created Procedure
select name,create_date
from sys.objects

where type='P' and DATEDIFF(d,create_date,GETDATE())<7


Hope this small tip would be beneficial for you in your coding. Till then enjoy !!

Thursday, June 27, 2013

Article - C# Corner

Hello Everyone, I have uploaded my article 'ASP.NET 4.5 Features - Key HTML Editor Features' on C# corner.
Below is the link for the same:

http://www.c-sharpcorner.com/UploadFile/e1a047/Asp-Net-4-5-features-key-html-editor-features/

Please read the article and get back to me in case of any questions.