Tag Archives: date

Exploration of SQLite

Recently got a chance to work on SQLite for a requirement to Purge Data based on Date Conditions.Collaborating all learning as part of perks of working on something new. 1. Date Function to Add Days in SQLite. As part of … Continue reading

Rate this:

Posted in SQLite Learning | Tagged , , , | Leave a comment

Date Generator in SQL Server using Recursive With Clause.

During one of performance analysis, identified lofty insert statements populating static tables with Date information. As part of one of functionality, we were generating dates and applying necessary function on it within date range specified. As part of performance improvement, … Continue reading

Rate this:

Posted in Helper SQL, SQL Server Learning | Tagged , , , | Leave a comment