ASP-NET-Samples

Wednesday, July 2, 2014

Get Table Names which are Modified in last few days in Sql Server



SELECT name 'Table',modify_date 'Last Modified Date'
FROM sys.tables WHERE  DATEDIFF(D,modify_date, GETDATE()) < 15
Posted by Prasad
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Post Older Post Home

ASP.NET Sample web links

  • Exporting data to Excel and CSV in ASP.NET MVC application
  • aspsnippets
  • csharp-corner
  • csharpdotnetfreak
  • csharpaspnet articles
  • aspdotnetcodes
  • DOTNET MIXER
  • MVC Samples
  • aspdotnetcodebook
  • Bind Gridview using Jquery
  • Generic Collections - Some Common List(T) Operations using C# 2.0 and VB.NET
  • DateTime Format in GridView ItemTemplate In Asp.net
  • JQuery + Asp.net
  • dailycoding

SQL Samples

  • Sql Date formates
  • Sql Date formates-2

HTML Tutorials

  • html-color-codes
  • Free Icons
  • CSS Gradient Button Generator
  • CSS Gradient Background Maker

JQuery Samples

  • jquerybyexample

Other Useful Links

  • Latest Software Downloads

Pages

  • ASP.NET
  • SQL
  • JQuery
  • CSS
Prasad. Picture Window theme. Powered by Blogger.