14 September 2012

Stored procedure that create in last N Days in Sql Server

Stored procedure that create in last N Days in Sql Server

SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 7
----Change 7 to any other day value.



-

No comments:

Post a Comment

Comments Welcome

Subscribe to: Post Comments (Atom)

Find number of letter occurence of all letter in c#

  Find number of letter occurence of all letter in c#  namespace ConsoleApp1 {     internal class Program     {         static void Main(st...